Job Title: Informatica Developer
Location:
Morristown NJ;
New York NY;
Purchase NY
Charlotte NC;
Conshohocken PA;
Dallas TX;
Houston TX
Alpharetta GA;
Chicago IL;
Colorado Springs CO;
Denver CO;
Fargo ND;
Garden City NY;
Jacksonville IL;
Lenexa KS;
Los Angeles CA;
Lubbock TX;
Mt Juliet TN;
Topeka KS
Skill : Informatica Development Oracle/Sql server Informatica Admin Insurance Domain
Mandatory:: Informatica Certification & Insurance domain is mandatory Note: This role is specifically for Informatica PowerCenter (On-Premise). It does not involve Informatica Cloud (IICS) or cloud-based data integration tools. Job Description: 8 years of hands-on experience in ETL development for a data warehouse development maintenance and enhancements of Informatica Mappings Workflows and processes.
- 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).
- This role is specifically for Informatica PowerCenter (On-Premise). It does not involve Informatica Cloud (IICS) or cloud-based data integration tools.
- 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.
- Experience working with complex SQL.
- Expertise with integration technologies and processes.
- Experience working with Query Surge.
- Experience with window environment.
- Possess knowledge of testing tools and techniques.
- Working knowledge of Kimball design methodology.
- Responsible for installing configuring and managing Informatica PowerCenter on-premise platform.
- Performs user management monitors server performance and handles Repository backups and recovery.
- Troubleshoots integration issues applies patches and ensures high availability and environment stability.
- Collaborates with developers DBAs and infrastructure teams to support ETL processes and optimize performance.
- Take care of ETL migrations across various environments