ETL Engineer

Charlotte, NC, United States

Moody’s is a developmental culture where we value candidates who are willing to grow. So, if you are excited about this opportunity but don’t meet every single requirement, please apply! You may be a perfect fit for this role or other open roles.

Moody's is a global integrated risk assessment firm that empowers organizations to make better decisions.

At Moody’s, we’re taking action. We’re hiring diverse talent and providing underrepresented groups with equitable opportunities in their careers. We’re educating, empowering and elevating our people, and creating a workplace where each person can be their true selves, reach their full potential and thrive on every level. Learn more about our DE&I initiatives, employee development programs and view our annual DE&I Report at moodys.com/diversity

We are seeking an experienced ETL Engineer to join our team. The successful candidate will have a deep understanding of the technical aspects of migrating ETL workloads from Informatica Power Center to AWS Glue. This role requires strong hands-on experience with Python & PySpark, AWS Analytics services, and various file formats such as XML, JSON, and Parquet.

Responsibilities:

Lead the migration of ETL workloads from Informatica Power Center to AWS Glue, ensuring a smooth transition and minimal disruption to business operations.

Develop and implement code and data migration strategies in collaboration with the client.

Perform multiple proofs of concept to demonstrate expertise in Informatica PC to Glue migration.

Serve as the owner for the overall migration solution, driving end-to-end migration of all in-scope ETL jobs.

Utilize knowledge of Informatica and AWS Glue to inform migration strategy.

Create and maintain Jenkins pipelines and develop Cloud formation templates for ETL solutions.

Identify potential blockers to migration and drive efforts to determine alternate solutions.

Engage with the Solution Designer to review and validate the detailed technical design for business applications.

Ensure on-time delivery, communicate effectively with sponsors, stakeholders, and project teams.

Experience working with job scheduling tools like Control-M is preferred. Experience with Tableau and Alteryx is an added advantage.

Requirements:

Bachelor’s degree in technology, Engineering or related field, or equivalent experience, Master’s degree is a plus.

5+ years of overall work experience with genuine hands-on experience in Informatica PC, Power Exchange.

Proficiency in AWS Glue, S3, Athena, Lambdas, API Gateways, EC2, MSK, R53.

Experience with Informatica, AWS Glue, Step Functions, Data Lake, Datamesh, RDS, Python, Pyspark, PL/SQL, Unix, Shell, Windows, Jenkins, GitHub, BitBucket, Vault, CDC concepts, Informatica to AWS Glue migration, Informatica Upgrades, and ETL framework and solutioning knowledge.

Strong organizational and multi-tasking abilities and the capability to prioritize and manage numerous concurrent projects.

Full lifecycle experience in waterfall and agile development methodologies.

Experience with Tableau and Alteryx is an added advantage.

Knowledge of databases: SQL, Oracle, Sybase, MySql, Aurora Postgres, Oracle, etc.

The successful candidate will be a self-starter, capable of working independently, and will have proven experience in managing multiple tasks and projects simultaneously.

For US-based roles only: the anticipated hiring base salary range for this position is[[$94,800]]-[[$137,400]], depending on factors such as experience, education, level, skills, and location. This range is based on a full-time position. In addition to base salary, this role is eligible for incentive compensation. Moody’s also offers a competitive benefits package, including not but limited to medical, dental, vision, parental leave, paid time off, a 401(k) plan with employee and company contribution opportunities, life, disability, and accident insurance, a discounted employee stock purchase plan, and tuition reimbursement.

Moody’s is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, sex, gender, age, religion, national origin, citizen status, marital status, physical or mental disability, military or veteran status, sexual orientation, gender identity, gender expression, genetic information, or any other characteristic protected by law. Moody’s also provides reasonable accommodation to qualified individuals with disabilities or based on a sincerely held religious belief in accordance with applicable laws. If you need to inquire about a reasonable accommodation, or need assistance with completing the application process, please email [email protected] . This contact information is for accommodation requests only, and cannot be used to inquire about the status of applications.

For San Francisco positions, qualified applicants with criminal histories will be considered for employment consistent with the requirements of the San Francisco Fair Chance Ordinance.

This position may be considered a promotional opportunity, pursuant to the Colorado Equal Pay for Equal Work Act.

Click here to view our full EEO policy statement . Click here for more information on your EEO rights under the law . Click here to view our Pay Transparency Nondiscrimination statement .Click here to view our Notice to New York City Applicants.

Candidates for Moody's Corporation may be asked to disclose securities holdings pursuant to Moody’s Policy for Securities Trading and the requirements of the position. Employment is contingent upon compliance with the Policy, including remediation of positions in those holdings as necessary.

For more information on the Securities Trading Program, please refer to the STP Quick Reference guide on ComplianceNet

Please note: STP categories are assigned by the hiring teams and are subject to change over the course of an employee’s tenure with Moody’s.

#J-18808-Ljbffr