Job Specifications
Job Summary
We are seeking a highly experienced Senior Informatica Developer with a strong background in integrating data with Snowflake. The ideal candidate will have a minimum of 5 years of reputable experience in ETL development using Informatica PowerCenter, Intelligent Data Management Cloud (IDMC, formerly IICS), or equivalent platforms, and will be responsible for designing, developing, and maintaining efficient data extraction and loading solutions involving Snowflake.
The successful candidate must demonstrate strong communication skills, a deep understanding of data warehousing principles, and a proactive approach to problem-solving and collaboration.
Key Responsibilities
Design, develop, and optimize ETL/ELT processes using Informatica to extract data from diverse source systems and load it into Snowflake.
Collaborate with data architects and stakeholders to understand business requirements and translate them into technical solutions.
Implement data transformations, quality checks, and validation logic to ensure high data accuracy and consistency.
Monitor, troubleshoot, and tune ETL jobs for performance, scalability, and reliability.
Document technical specifications, data mappings, and process flows in alignment with data governance standards.
Work closely with QA, DevOps, and data engineering teams to support deployment, testing, and production support.
Maintain best practices for secure, scalable, and reusable data integration components.
Required Qualifications
Bachelor's degree in Computer Science, Information Systems, or a related field.
Minimum 5 years of hands-on experience developing ETL solutions using Informatica (IDMC).
Proven experience with data integration into Snowflake, including performance tuning and cost optimization.
Strong expertise in writing SQL and working with structured and semi-structured data (JSON, XML, etc.).
Familiarity with cloud ecosystems (AWS, Azure, or GCP) and related services for data storage and processing.
Excellent verbal and written communication skills, with the ability to interact effectively with both technical and non-technical stakeholders.
Experience in Agile/Scrum environments and participation in code reviews, sprint planning, and backlog grooming.
About the Company
Pacific Data Integrators (PDI) stands at the forefront of innovation, harnessing the power of AI/ML and cutting-edge large language models such as GPT-4, LLaMA-2, and Dolly to deliver unparalleled data solutions. Our expertise in cloud technology, data management, data governance, and analytics empowers leading organizations to overcome their most pressing business challenges, enhance decision-making, and realize their strategic goals. As a trusted partner of industry giants like Informatica, Databricks, Google, AWS, Microso...
Know more