Previous Job
Previous
Sr ETL Developer – Informatica
Ref No.: 18-52645
Location: McLean , VA, Virginia
Position Type:Direct Placement
Start Date: 07/25/2018
Role:  Sr ETL Developer – Informatica
location: McLean , VA
Duration: Full time
• At least 5+ years of experience in developing ETL solutions using Informatica PowerCenter.
• Experienced in designing and developing Informatica PowerCenter ETLs for DB2/MS SQL Server/Oracle Database loads
• Hands on experience working in data migration projects
• Experienced of working in MS SQL/ Oracle Server database.
• Hands on development and maintenance experience in shell scripting
• Work with business team to understand and design ETL solution for requirements.
• Hands on experience in performance tuning Informatica PowerCenter Mappings, capacity planning and developing High Volume Data Loads.
• Strong experience in developing efficient SQLs for querying RDBMS Systems.
• Hands on experience with version control systems like GIT.
• Experienced working in an Agile environment.
• Strong communication skills

High preference for candidates with below additional skills
• Strong in SQL development and shell scripting
• Experienced with Procedural Language development.
• Exposure to Banking/Mortgage domain will be plus
• Provide technical leadership and support for inbound/outbound data integration (ETL), maintenance/tuning of applications, data model changes, data profiling, data quality assessment, executing and monitoring incremental updates, and working with infrastructure and DBA teams to maintain multiple environments (development/test/production).
• Knowledge on Data Modelling and familiarity with Dimension and Fact tables design.
• Strong SQL performance tuning capabilities for relational DB.
• Strong UNIX and shell scripting experience is required Autosys scheduling experience.
• Must be detail oriented and possess strong problem-solving skills.
• Design, develop and test PowerCenter mappings and workflows.
• Develops scripts to execute and test mappings and workflows.
• Must be facilitating the establishment and implementation of standards, guidelines and best practices that guide the various PowerCenter and Data Warehouse projects within the organization.
• Able to provide data architecture solutions.
• Strong analytical and technical aptitude experience required.
• Work with migration team and push code changes to production.
• Coordinate and work with testing teams during integration testing phases
• Collaborate with source systems data stewards and technical personnel for data governance and to resolve any data quality or technical issues related to data ingestion.
• Must be experienced on both; Linux & Windows operating systems.
• Providing guidance and assistance to team members