Informatica Developer duties and responsibilities
- Informatica developer needed to develop and enhance ETL workflows from various sources to MSSQL database/PostgreSQL DB
- Performs development activities using Informatica IDMC services.
- Creates, maintains, and optimizes stored procedures, functions, inline SQL, database structures, and ETL processes to adapt to changes in needs and requirements.
- Plans and conducts Unit, SIT and UAT tests.
- Uses standard data modeling, data flow, and data documentation tools to analyze, document and present data analysis work.
- Works cooperatively with others to resolve data and process issues.
- Works with non-technical, subject matter experts to understand underlying data behavior and characteristics in ways that will be new for such non-technical people.
- Responsible for developing and managing ETL configurable artifacts (code, environment, configuration files, documentation).
- Provide post-production application support as required.
Informatica ETL Developer qualifications
- BS/MS degree in Computer Science, Engineering, or a related subject.
- Must have 5 to 8 years of ETL experience.
- Current experience with Informatica PowerCenter v10.5+.
- Experience with migration of Informatica PowerCenter to IDMC.
- Experience with performance tuning of sources, mappings, targets and sessions.
- Familiarity with Microsoft SQL Server/PostgreSQL DB.
- Excellent understanding of T-SQL programming.
- Ability to work with development and operations teams to tune production queries for optimal performance.
- Experience with Data Architecture and Data Modeling concepts is a plus.
- Knowledge of git Source Control. and Knowledge of CI/CD pipelines or deployment automation tools.
- Critical thinker and problem-solving skills.
- Team player.
- Good time management skills.
- Great interpersonal and communication skills.