IC
Informatica Developer
Infinite Computer Solutions
- 🇺🇸 United States
- On-site
- 2 days ago
- ETL
- Informatica
- Oracle
- SAP
- Unit Testing
- Snowflake
- SQL
- PL/SQL
2 days ago
Job description
Job Title: Data Warehouse ETL DeveloperJob Summary:
We are seeking a skilledData Warehouse / ETL Developer with expertise inInformatica PowerCenter to design, develop, and maintain enterprise-level ETL solutions. The ideal candidate will have hands-on experience in data warehousing concepts, ETL processes, and strong problem-solving skills to ensure high-quality, timely, and accurate data integration.
Key Responsibilities:
- Design, develop, and deployETL mappings, workflows, and sessions using Informatica PowerCenter.
- Extract data from heterogeneous source systems (e.g., Oracle, SQL Server, flat files, SAP) and load into target data warehouse environments.
- Collaborate with business analysts and data architects to understand data requirements and translate them into efficient ETL solutions.
- Optimize ETL processes for performance, scalability, and maintainability.
- Conduct data validation, reconciliation, and troubleshooting to ensure data quality and integrity.
- Maintain ETL documentation, including data flow diagrams, technical specifications, and process design documents.
- Participate in code reviews, unit testing, and UAT support.
- Monitor ETL jobs and workflows, identify bottlenecks, and implement improvements.
- Provide production support and resolve data-related issues in a timely manner.
Required Skills and Qualifications:
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- 7+ years of experience in ETL development usingInformatica PowerCenter.
- Strong understanding ofdata warehousing concepts, dimensional modeling, and star/snowflake schemas.
- Experience withSQL, PL/SQL, and performance tuning of database queries.
- Knowledge of data quality, data governance, and best practices in ETL development.
- Strong analytical, problem-solving, and communication skills.
- Experience with version control systems and ETL deployment processes.
Preferred Qualifications:
- Exposure toreal-time ETL and data streaming technologies.
- Knowledge of scheduling tools such asInformatica Workflow Manager and IBM Workload Automation
Â
- Qualifications: Graduate
- Range of Year Experience-Min Year: 10
- Range of Year Experience-Max Year: 12
Informatica Developer · Infinite Computer Solutions