Required Skills

ETL development

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 9th Feb 2024

JOB DETAIL

 

ROLE SUMMARY
The Informatica Developer will be primarily responsible for developing and supporting ETL code in Informatica
PowerCenter for an enterprise data warehouse.
ROLE RESPONSIBILITIES
 Develop new ETL and enhancements and modify existing code using Informatica PowerCenter. Work
independently to develop, configure, and unit test programs from specs (source to target mappings).
 Work closely with data architects, reporting team and application team on ETL development efforts.
 Design and document ETL solutions for projects, estimate work effort and provide status of tasks.
 Provide technical support for the administration and production support of Informatica.
 Provide first and second level troubleshooting, and baseline and operational support.
 Adhere to best practices and methodologies for ETL development team.
 Present all work in design and code review sessions to senior team members.
 Prepare documents that describe, and support code developed.
 Identify improvements to the data warehouse environment. Work with the team to implement these
solutions.
 Escalate issues to the right party when required.
TECHNICAL QUALIFICATIONS
 10+ years of hands-on experience in ETL development for a data warehouse.
 10+ years of hands-on experience in development, maintenance, and enhancements of Informatica
Mappings, Workflows, and processes.
 8+ years of leadership experience, includes the management and coordination of an Informatica team.
 Has experience working with complex SQL.
 Expertise with integration technologies and processes.
 Has Query Surge experience.
 Candidate has window environment experience.
 Possess knowledge of testing tools and techniques.
 Has a working knowledge of Kimball design methodology.
GENERAL QUALIFICATIONS
 Excellent analytical, organization, presentation, and facilitation skills.
 Possess the ability to handle multiple tasks under tight deadlines.
EDUCATION REQUIREMENTS
 Bachelor's degree in Computer Science, MIS, related field, or equivalent experience.

Company Information