Informatica ETL Senior Developer/Lead

Role: Informatica ETL Senior Developer/Lead

Designation: Senior / Lead Data Engineer

Experience: > 5 yrs.

Work Location: Hyderabad, Telangana

Qualification: Bachelor’s degree in computer science, Information Systems, or related field

Brief description about the role:

The Informatica ETL Lead developer will be responsible for designing, developing, and maintaining the ETL processes and systems that are used to move data from various sources into a data warehouse or other target systems using Informatica platform technologies. The candidate should be able to design and develop the architecture for a robust ETL/ELT platform using on-prem or cloud-based solutions. He should be able to mentor, coach and lead a team of developers and leads in implementing such solutions.

Key Roles & Responsibilities:

• Develop and implement ETL strategy in collaboration with stakeholders.
• Lead and manage ETL projects from initiation to completion, ensuring that project goals and objectives are met within budget and on time.
• Manage and lead the ETL team, including hiring, training, and coaching team members.
• Collaborate with stakeholders, including business leaders, data owners, and IT teams, to understand their data requirements and ensure that master data meets their needs.
• Establish and maintain data governance policies and procedures to ensure compliance with data privacy and security regulations.
• Willingness to pick up new technologies and develop POCs and MVPs for demonstrations.
• Leverage tools & technologies like Informatica Powercenter/IICS
• Designing & developing data loads & transformations, master workflows, exception handling
• Integrate Data Quality (IDQ) rules & data reconciliation as part of orchestration.
• Craft SQL queries using joins, aggregates, merge/upsert etc.
• Design and create logical and physical data models that capture the structure and relationships of data entities.
• Ensure data models adhere to data normalization, denormalization, and indexing principles for optimal performance

Skills

• 5+ years of experience in Informatica Power Center, IDMC, IICS, ETL, data warehousing, or related field using Informatica’s suite of products and solutions.
• Design and create logical and physical data models that capture the structure and relationships of data entities.
• Ensure data models adhere to data normalization, denormalization, and indexing principles for optimal performance.
• Strong knowledge of implementing Master data management solutions in Informatica, Reltio or any other similar tools.
• Strong understanding of data governance, data quality, and data management best practices
• Good experience in Unix shell scripting and Python.
• In depth understanding of data warehousing concepts and their applications.
• In-depth understanding of CDC, SCDs and their implementations.
• In depth expertise on handling structured, semi-structured and un-structured files.
• Experience of working in cloud data warehouse such as Snowflake, Databricks, Redshift etc.
• Strong data analysis skills. Proficient in writing complex and efficient SQL queries and tuning them for performance when required.
• In depth understanding of data integration tools and technologies such as Informatica PowerCenter and RDBMS concepts.
• Knowledge of python will be preferred.
• Excellent communication, collaboration, and leadership skills
• Familiarity with iterative development methodologies (Agile, Scrum).
• Experience using Github and Apache Airflow.