

Sr. Informatica IDMC & SQL Developer
β - Featured Role | Apply direct with Data Freelance Hub
This role is for a Sr. Informatica IDMC & SQL Developer, offering a contract length of "unknown" at a pay rate of "unknown." Key skills required include ETL development with Informatica, Snowflake integration, and strong SQL expertise. A Bachelor's degree and 5 years of relevant experience are mandatory.
π - Country
United States
π± - Currency
$ USD
-
π° - Day rate
-
ποΈ - Date discovered
July 18, 2025
π - Project duration
Unknown
-
ποΈ - Location type
Unknown
-
π - Contract type
Unknown
-
π - Security clearance
Unknown
-
π - Location detailed
United States
-
π§ - Skills detailed
#Deployment #Data Engineering #Cloud #Data Management #Data Accuracy #AWS (Amazon Web Services) #Data Transformations #Agile #Informatica #Scrum #Data Mapping #Snowflake #Azure #JSON (JavaScript Object Notation) #Code Reviews #IICS (Informatica Intelligent Cloud Services) #Data Integration #Data Extraction #Informatica PowerCenter #Storage #Data Governance #GCP (Google Cloud Platform) #DevOps #SQL (Structured Query Language) #XML (eXtensible Markup Language) #Data Architecture #Computer Science #Scala #"ETL (Extract #Transform #Load)" #Data Storage
Role description
Heading 1
Heading 2
Heading 3
Heading 4
Heading 5
Heading 6
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Block quote
Ordered list
- Item 1
- Item 2
- Item 3
Unordered list
- Item A
- Item B
- Item C
Bold text
Emphasis
Superscript
Subscript
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 (PowerCenter and/or 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.