Associate Informatica Engineer

As a

Software Engineer

• Analyze business and functional requirements to design and implement scalable data integration solutions.
• Understand and interpret High-Level Design (HLD) documents and convert them into detailed Low-Level Design (LLD).
• Develop robust, reusable, and optimized Informatica mappings, sessions, and workflows.
• Conduct peer code reviews and suggest improvements for reliability and performance.
• Prepare and execute comprehensive unit test cases and support system/integration testing.
• Maintain detailed technical documentation, including LLDs, data flow diagrams, and test cases.
• Build data pipelines and transformation logic in Snowflake, ensuring performance and scalability.
• Develop and manage Unix shell scripts for automation, scheduling, and monitoring of ETL jobs.
• Collaborate with cross-functional teams to support UAT, deployments, and production issues.

Requirements:

You are a fit for this position if your background includes:

• 2-4 years of strong hands-on experience with

  Informatica PowerCenter

  .
• Proficiency in developing and optimizing

  ETL mappings

  , workflows, and sessions.
• Solid experience with

  performance tuning

  techniques and best practices in ETL processes.
• Hands-on experience with

  Snowflake

  for data loading, SQL transformations, and optimization.
• Strong skills in

  Unix/Linux scripting

  for job automation.
• Experience in converting

  HLDs

  into

  LLDs

  and defining

  unit test cases

  .
• Knowledge of

  data warehousing concepts

  ,

  data modeling

  , and

  data quality frameworks

  .

Good to Have:

• Knowledge of

  Salesforce data model

  and integration (via Informatica or API-based solutions).
• Exposure to

  AWS cloud services

  like S3, Glue, Redshift, Lambda, etc.
• Familiarity with relational databases such as

  SQL Server

  and

  PostgreSQL

  .
• Experience with

  job schedulers

  like

  Control-M

  ,

  ESP

  , or equivalent.

• Agile methodology

  experience and tools such as

  JIRA

  ,

  Confluence

  , and

  Git

  .
• Knowledge of

  DBT (Data Build Tool)

  for data transformation and orchestration.
• Experience with

  Python scripting

  for data manipulation, automation, or integration tasks.