Roles & responsibilities:
- Informatica PowerCenter developer needed to develop and enhance ETLs from various sources to MSSQL database & Postgresql.
- Perform advanced ETL development activities using Informatica, MSSQL Database tuning, SQL tuning, Informatica Server. administration Create, maintain, and optimize stored procedures, functions, inline SQL, database structures, and ETL processes to adapt to changes in needs and requirements.
- MSSQL experience from the development perspective (database and application).
- Plans and conducts Informatica ETL unit and development 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
- Work as team lead or part of team to deliver the projects
- Follow established standards, best practices, and provide input for improvement of those processes
Requirements:
- Must have 4 years of ETL experience
- Current experience with Informatica PowerCenter v10.3+
- Experience with migration of Informatica PowerCenter to Informatica Intelligent Cloud is a plus
- Experience with Data Architecture and Data Modeling concepts Experience with performance tuning of sources, mappings, targets and sessions
- Excellent understanding of T-SQL programming
- Familiarity with Microsoft SQL Server
- Knowledge of git Source Control. and Knowledge of CI/CD pipelines or deployment automation tools.
- Ability to work with development and operations teams to tune production queries for optimal performance.
