Datastage ETL Developer / Sr ETL Developer
Previous Job
Previous
Datastage ETL Developer / Sr ETL Developer
Ref No.: 18-22733
Location: McLean, Virginia
Position Type:Direct Placement
Start Date: 04/04/2018
119712 (exp 5-8)    5579711-12    

Datastage ETL Developer    
MUST HAVE SKILLS
• Experience of working in DB2/Oracle/MS SQL Server Databases.
• Work with business team to understand and design ETL solution for requirements.
• Hands on experience in performance tuning DataStage Jobs (Parallel/Server), capacity planning and developing high volume data loads.
• Experienced in developing Sequencer Jobs, routines. 
• Good knowledge about Orchestrate commands
• Strong experience in developing efficient SQLs to query Relational Databases.
• Hands on experience with version control systems like GIT, SVN.
• Experience in developing Procedural Language is a plus.
• Experienced working in an Agile environment.
• Exposure to Banking/Mortgage domain will be plus
• Strong communication skills

Secondary Skills
• Exposure to Banking/Mortgage domain will be plus

Responsibilities
• 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).
• Strong performance tuning capabilities with DB2, Oracle, and stored procedures.
• 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 IBM DataStage Jobs and Sequences.
• 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 DataStage 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. 

Sr ETL Developer MUST HAVE SKILLS
• 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

Secondary Skills
• Experienced with Procedural Language development.
• Exposure to Banking/Mortgage domain will be plus

Responsibilities
• 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