IICS Developer

Informatica (IDMC/IICS) - Mid / Senior

Key Responsibilities:

• 6+ years of strong prior working experience in ETL tools and 5+ years working experience in IDMC/IICS
• Develop business critical Informatica entities using IDMC/IICS Informatica Intelligent Cloud Services (CDI - (cloud data integration), Monitor, CAI - (cloud application integration)).
• Conduct requirements analysis, design, and implementation activities in full lifecycle reporting and analytics solutions.
• Should be familiar with bulk loading concepts, external tables and advanced snowflake concept etc
• Responsible to handle high volume data loads/migrations.
• Experienced in designing optimal data load and data processing ETL jobs.
• Responsible to guide and lead the team.
• Responsible to guide the team in agile methodology.
• Should have prior experience working with cloud technologies.
• Should have prior experience working with different types of data sources/targets.
• Responsible to handle end to end lifecycle from analysis through deployment.
• Strong SQL and T-SQL Skills.
• Sourcing, Mapping, and Coding data transformations and data pipelines.
• Develop and deliver technical and functional presentations to the internal project team and client organizations.
• Developing prototypes, to demonstrate the value of data-driven technologies.
• Working collaboratively in a team-based environment to build lifecycle data and analytics solutions.
• Should be able to navigate Unix scripts and create code as required for the project.
• Should have prior experience working with Dimensional model; and understand data warehousing concepts. Should know how to work with SCD logic.
• Experience working with Snowflake Database is good to have.
• Experience in using Scheduling tools (Control M)

Qualifications:

• Bachelors degree in computer science, data engineering, or a related field.
• Minimum of 5 years of professional experience in data engineering.
• Proficiency in Informatica IDMS/IICS, Snowflake & SQL.
• Strong understanding of data warehousing concepts and best practices.
• Familiarity with data modelling and big data architectures.
• Strong problem-solving and troubleshooting skills.
• Excellent communication and collaboration skills.
• Ability to work independently and as part of a team.
• Knowledge of cloud data warehouses (e.g., snowflake)
• Key Skills: Data Integration, Data Migration, Data warehousing, Informatica IDMC/IICS, Snowflake
• Good to have:
• Certification on Informatica IDMC/IICS