Informatica Lead - ETL/SQL

Role : Informatica Lead.

Mode : Onsite 5 days(Rotational Shift 24-7).

Location : Mumbai (Kurla).

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.