Job Description
• Must have minimum 5 years’ experience in Informatica PowerCenter using various transformations, ETL Framework and Design/Development.
• Develop ETL Solutions using IICS Data Integration/Application Integration handling large data volumes
• Must have working knowledge in handling various source/target systems including XML/Flat files/Databases using PowerCenter/Informatica MFT/ IICS File Ingestion.
• Experience in working Agile/Sprint projects and exposure to Azure DevOps is a plus
• Experience in change data capture, Data warehousing, SQL, SQL server and Unix shell scripting
• Prior DataStage and Azure cloud platform experience is an advantage.”
- Technology Skills and Project Experience
- 5years of experience in ETL design development and business system designs
- Minimum 3years hands on experience in Informatica Cloud IICS ETL development
- Development experience in Informatica PowerCenter also is an added advantage.
- 3years of Redshift or Oracle or comparable database experience with BIDW deployments
- Must have proven experience with STAR and SNOWFLAKE schema techniques.
- Development experience in minimum 1year in Python scripting and Unix scripting is an added advantage.
- Familiar with AWS technologies
- Proven track record as an ETL developer in delivering successful business intelligence developments with complex data sources.
- Strong analytical skills and enjoys solving complex technical problems.
- Business Soft Skills.
- Must have solid presentation communication on complex technical solutions and interpersonal skills.
- Ability to work effectively with globally dispersed stakeholders from business.
- Ability to manage multiple priorities in a fast-paced environment.
- A data driven mind set ability to clearly communicate complex business problems and technical solutions.
- Ability to manage and make decisions about competing priorities and resources.
- Ability to delegate where appropriate.
- Must be a strong team player.