What are the responsibilities and job description for the Informatica Tech Lead position at Novia Infotech?
Responsibilities:
- Lead Integration migration from SSIS or any other ETL tool to Informatica Cloud Services (IICS/IDMC)
- Experienced implementing various Integration patterns like API, publish-subscribe, real-time architecture framework
- Participate in ETL Design of new or changing mappings and workflows with the team and prepare Technical Specifications
- Analyze data integration requirements, analyzing data sources and targets, business rules, and transformation logic
- Develop interface design specifications to source data from flat files and RDBMS as well as send extracts in various data formats
- Develop and maintain integration mappings, transformations, and orchestration workflows
- Ensure data integrity, consistency, and security throughout the integration processes
- Perform data analysis and profiling to identify data quality issues and develop strategies for data cleansing and transformation
- Collaborate with cross-functional teams to understand and address data requirements
- Ensure data accuracy and consistency across all systems
- Conduct unit testing, integration testing, and performance testing for ETL processes
- Maintain documentation of ETL processes, data flows, and mappings
Required Skills & Experience:
- 10 years of experience in ETL development using IICS (Informatica Intelligent Cloud Services)/IDMC (Intelligent Data Management Cloud)
- Hands-on development experience with Informatica Cloud (IICS/IDMC) technologies to create reusable framework
- Familiarity with IICS capabilities and have hands-on experience implementing features like Dynamic Mapping Task etc.
- Good understanding of ETL and ELT best practices and experience with ETL and ETL mapping documentation
- Working knowledge of Data Lake medallion architecture
- Experience in designing and implementing ETL processes; understanding of data models and data flows
- Basic understanding of data integration and data quality principles
- Ability to work collaboratively in a team environment
- Experience with cloud integrations, preferably Azure
- Experience leading technical development teams
- Working experience with Agile Methodologies
- Experience in creating and configuring APIs, services, and implementing real-time solutions using CAI is an added advantage
- Knowledge and experience with Databricks SparkSQL is an added advantage
