Description

You will design, develop, and maintain ETL workflows and data pipelines to support analytics and marketing requirements.

Responsibilities

• Define and maintain Informatica ETL mappings, scripts, and workflows in Linux environments.
• Translate business requirements into detailed ETL technical specifications and procedural SQL programs.
• Perform ETL and SQL tuning to optimize code performance and processing methods.
• Execute design validation, reconciliation, and error handling for initial and incremental load processes.
• Support the production batch environment and assist in developing system integration test plans.

Required Skills

• 5+ years of experience in data engineering or related technical work.
• Hands-on experience building complex business logic and ETL workflows using Informatica IICS and PowerCenter.
• Proficiency in SQL and PL/SQL.
• Strong experience with Python and AWS native technologies.
• Working knowledge of AWS services including Lambda, Glue, Kinesis, Lake Formation, S3, and Redshift.
• Experience with data warehousing concepts, data cleansing, and data validation.
• Solid understanding of the System Development Life Cycle (SDLC).

Preferred Skills

• Experience with Spark EMR, RDS, EC2, Athena, CloudWatch, and CloudTrail.
• Knowledge of Snowflake, Java development, Shell scripting, or Autosys.
• Experience with Business Intelligence tools such as Tableau, Cognos, or ThoughtSpot.

Key Skills

Education

Bachelor’s Degree