Job Details
Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:
Skills And Tools:
Job Description
Description
About the Role
We are seeking an experienced ETL/ODS Developer with strong expertise in Informatica to design, develop, and maintain data integration solutions. The candidate will be responsible for building robust ETL processes, managing data flows, and supporting the organization’s operational data store (ODS) and data warehouse environments.
Key Responsibilities
- Design, develop, and optimize ETL processes using Informatica PowerCenter / IICS.
- Build and maintain ODS layers and data pipelines to support reporting and analytics.
- Analyze data requirements, source-to-target mappings, and data transformation rules.
- Ensure data quality, integrity, and consistency across systems.
- Monitor ETL jobs, troubleshoot issues, and provide performance tuning.
- Work closely with data architects, DBAs, and BI teams to deliver end-to-end solutions.
- Develop and maintain technical documentation (ETL workflows, mappings, job schedules).
Job Requirements
Requirements
- Bachelor’s degree in Computer Science, Information Systems, or related field.
- Minimum 2 years of hands-on experience in ETL development using Informatica.
- Strong SQL skills and experience with Oracle, SQL Server, or PostgreSQL.
- Experience with ODS and Data Warehouse design principles.
- Knowledge of data modeling, normalization, and schema design.
- Familiarity with scheduling tools (Control-M, Autosys, etc.).
- Strong analytical and problem-solving skills.
Nice to Have
- Experience with cloud data platforms (AWS Redshift, Azure Synapse, GCP BigQuery, Snowflake).
- Knowledge of Python or Shell scripting for automation.
- Exposure to Agile/Scrum environments.
- Informatica certification is a plus.
