Informatica Lead - ETL/SQL

Role :

Mode :

Location :

Required Skills

• 6-10 years of experience in ETL development and data integration, with at least 3 years in a lead role.
• Proven experience with Informatica PowerCenter, Informatica Cloud Data Integration, and large-scale ETL implementations.
• Experience in integrating data from various sources such as databases, flat files, and APIs.
  

Preferred Skills

• Strong expertise in Informatica PowerCenter, Informatica Cloud, and ETL frameworks.
• Proficiency in SQL, PL/SQL, UNIX shell scripting and performance optimization techniques.
• Knowledge of cloud platforms like AWS, Azure, or Google Cloud.
• Familiarity with big data tools such as Hive, Spark, or Snowflake is a plus.
• Strong understanding of data modeling concepts and relational database systems.
  

Responsibilities

ETL Development and Maintenance :

• Lead the design, development, and maintenance of ETL workflows and mappings using Informatica PowerCenter and Cloud Data Integration.
• Ensure the reliability, scalability, and performance of ETL solutions to meet business requirements.
• Optimize ETL processes for data integration, transformation, and loading into data warehouses and other target systems.
  

Solution Architecture And Implementation

• Collaborate with architects and business stakeholders to define ETL solutions and data integration strategies.
• Develop and implement best practices for ETL design and development.
• Ensure seamless integration with on-premises and cloud-based data platforms.
  

Data Governance And Quality

• Establish and enforce data quality standards and validation processes.
• Implement data governance and compliance policies to ensure data integrity and security.
• Perform root cause analysis and resolve data issues proactively.
  

Team Leadership

• Manage, mentor, and provide technical guidance to a team of ETL developers.
• Delegate tasks effectively and ensure timely delivery of projects and milestones.
• Conduct regular code reviews and performance evaluations for team members.
  

Automation And Optimization

• Develop scripts and frameworks to automate repetitive ETL tasks.
• Implement performance tuning for ETL pipelines and database queries.
• Explore opportunities to improve efficiency and streamline workflows.
  

Collaboration And Stakeholder Engagement

• Work closely with business analysts, data scientists, and application developers to understand data requirements and deliver solutions.
• Communicate project updates, challenges, and solutions to stakeholders effectively.
• Act as the primary point of contact for Informatica-related projects and initiatives.