Data Warehouse Developer II / Senior ETL Developer / Informatica Developer
This role is responsible for designing, developing, testing, and implementing ETL solutions using Informatica Intelligent Data Management Cloud (IDMC).
The selected consultant will:
• Design, develop, test, and deploy ETL pipelines using IDMC
• Develop task flows, mappings, reusable transformations, and parameter files
• Perform metadata management and repository administration
• Ensure data accuracy, security, scalability, and performance optimization
• Support migration from Informatica PowerCenter to IDMC
• Collaborate with business users, analysts, architects, and technical teams
• Perform troubleshooting and resolve ETL/data performance bottlenecks
• Support production deployment, maintenance, and enhancements
• Follow enterprise data warehousing standards and best practices
REQUIRED SKILLS
Mandatory:
• 4+ years of Data Warehouse design and development
• 3+ years of hands-on Informatica Intelligent Data Management Cloud (IDMC) experience
• 4+ years of Informatica PowerCenter experience
• Strong SQL and Data Analysis experience (4+ years)
• Experience with Oracle Database, IBM Db2, and/or Microsoft SQL Server
• Experience with dimensional modeling, fact/dimension tables, SCD, and Kimball methodology
• ETL performance tuning and optimization
• Experience with Control-M job scheduling
• Requirements gathering and technical documentation
• Test plans, test cases, defect management
• Excellent written and verbal communication skills
Preferred / Nice to Have:
• Business Intelligence tools like SAP BusinessObjects
• Dashboarding tools like Tableau
• Government or State agency experience
• Experience with privacy and compliance regulations