Job Description :
Hi,
I am Gauri from Idexcel
We have an urgent opening for “ Informatica ETL Developer” please let me know if you are interested in pursuing this opportunity.
Below is the detailed Job description.
Title : Informatica ETL Developer
Location : Herndon, VA
Duration : Long-term
Position Description
Client has an immediate need for an Informatica ETL Developer to join our financial services team in Herndon, VA. This is an exciting full-time opportunity to work in a fast-paced team environment supporting one of the largest leaders in the secondary mortgage industry. We take an innovative approach to supporting our client, working side-by-side in an agile environment using emerging technologies.
Your future duties and responsibilities
Provides technical direction in the maintenance and development of the extract, transform and load (ETL) aspects of the data warehouse. Maintains an understanding of the inputs received from the data source providers. Performs analysis, design, development, and implementation of new ETL requirements. Recommends changes to enhance the data warehouse data cleansing and conversion processes. Supports testing and validation of the new data conversion processes. Responsible for planning and monitoring schedule milestones and deliverables for assignments. Possesses strong SDLC experience and manages appropriate levels of systems documentation as required.
Required qualifications to be successful in this role
8 years of experience with Informatica PowerCenter
8 years of experience with Informatica Data Quality
4 Years of experience with Informatica PowerExchange (change data capture)
Design, develop, test, implement, and troubleshoot ETL mappings and workflows in a large Data Warehouse environment
Strong experience developing and maintaining Informatica mappings/workflows in a data warehouse environment
Strong experience optimizing Informatica mappings, sessions and workflows
Experience writing complex SQL, PL/SQL and Performance Tuning is a plus
Strong database experience, data analysis and analytical skills
Experience creating ETL design documentation and maintaining overall design document and deliverables
Strong working experience of the SDLC processes
Strong written and oral communication skills
Good understanding of dimensional modeling and ETL designs for loading Star Schemas
Bachelor’s Degree in Computer Science, Computer Engineering, Information Systems, or other applicable discipline