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.

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.

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.

Associate Informatica Engineer