Informatica ETL Developer HP - Pratima

Responsibilities:

• Handson experience in tuning mappings identifying and resolving performance bottlenecks in various levels like sources targets mappings and sessions. Responsible for all activities related to the development implementation administration and support of ETL processes for large scale data warehouses using Informatica Power Centre.

• Performs analysis of complex functional and business requirements. Prepares code stubs for others. Completes code to implement solutions.

• Participates in crossfunctional teams. Designs prepares and executes Unit tests.

• Demonstrates technical experience/skills and exerts influence outside of immediate team.

• Applies indepth or broad technical knowledge to provide maintenance solutions across one or more technology areas.

• Performs solution design. Applies the company and 3rd party technologies and leads design of highly complex infrastructure and software solutions.

• Integrates technical expertise and business understanding to create superior solutions for the company and customers. Mentors and consults with team members and other organizations customer and vendors on complex issues.

• Leveraging your extensive background in development you will collaborate closely with business subject matter experts and work in tandem with a crossfunctional team including Business Analysts Architects Developers Project Managers and external vendors.

Skills And Experience

• 10 years of experience in IT on ETL Informatica development and databases like Oracle/SQL Server and etc and strong experience in Data Warehousing. .

• Indepth understanding of fundamental DataWarehousing concepts
  Strong skills in Data Analysis Data Requirement Analysis and Data Mapping for ETL processes.
  Experience in database programming in PLSQL (Stored Procedures Triggers and Packages).
  Handson experience in tuning mappings identifying and resolving performance bottlenecks in various levels like sources targets mappings and sessions.
  Extensive experience in development and maintenance using SQL Server SQL PLSQL SQL Loader.
  Well versed in developing the complex SQL queries unions and multiple table joins and experience with Views.

• Basic understanding of Software Test methodologies test scripting and testing tools.

• Expertise in design develop and optimize stored procedures and functions in Informatica.

• Good and quick at analysing existing SQL queries for performance improvements.

• Experience in advanced SQL JSON / XML Formatting etc. preferred Open to learn any data integrations tool and project application related tools.

• Good verbal and written communication skills; influencing skills and ability to work effectively in a geographically dispersed team. Demonstrated technical leadership skills.