ETL (Informatica) Lead/Architect

Roles & Responsibilities

• Design and implement scalable ETL solutions using Informatica PowerCenter
• Develop enterprise data integration architecture and data migration strategies
• Analyze source systems and create efficient data mapping and transformation logic
• Build and maintain data pipelines for data warehouses and analytics platforms
• Optimize ETL performance, scalability, and reliability
• Troubleshoot ETL failures, data discrepancies, and production issues
• Create technical design documents, architecture diagrams, and best practices
• Lead code reviews, deployment planning, and ETL framework improvements
• Support cloud migration and modernization initiatives

Qualifications

• Must have 5+ years of experience as an ETL Architect with Informatica expertise
• Strong experience with Informatica PowerCenter and Informatica IDMC
• Expertise in ETL/ELT architecture and data warehousing concepts
• Strong SQL and database development skills, including experience with Oracle Database, Microsoft SQL Server, DB2, Yellowbrick, BigQuery
• Knowledge of data modeling techniques (Star Schema, Snowflake Schema)
• Experience with cloud platforms: Google Cloud, Informatica IDMC
• Familiarity with Unix/Linux shell scripting
• Understanding of DevOps, CI/CD, and version control

Pay

Base Salary Range: $100,000 to $120,000 per annum

Benefits

• Discretionary Annual Incentive
• Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans
• Family Support: Maternity & Paternity Leaves
• Insurance Options: Auto & Home Insurance, Identity Theft Protection
• Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement
• Time Off: Vacation, Time Off, Sick Leave & Holidays
• Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing