Job ID :
2853
Company :
DC Government
Location :
washington, DC
Type :
Contract
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
5 years ago
Job Seekers, Please send resumes to resumes@hireitpeople.com or Call: (202) 719-0200 Ext: 127

Complete Description:

The selected candidate shall work with MPD’s Quality Assurance team to identify and resolve data quality issues related to a large legacy data conversion project. The selected candidate should be able to analyze and document rules provided by the business team and design ETL objects to implement and verify them. This candidate will spend a major portion of his/her time writing complex SQL queries to analyze and resolve legacy data quality issues in a data conversion project. This candidate must be meticulous in all project tasks. The candidate must have strong verbal skills and must be able to communicate with non-technical people. He/she must also be able to write clear explanations of complex topics, as much of MPD’s correspondence is handled through e-mail.

 

Required Qualifications:

•          Strong SQL querying knowledge of SQL Server 2005 and above

•          Strong SQL querying knowledge of Oracle 10g and above

•          Basic knowledge of performance tuning of long-running SQL queries using Oracle & SQL Server

•          Must have worked on Informatica 8.6.1 or 9.x.

•          At least 6 years experience working with Informatica Power Center

•          Strong knowledge in design, development, testing, and implementation of ETL jobs in Informatica Power Center

•          Working knowledge of ETL processes and Informatica Best Practices based on industry standards

•          Ability to gather business requirements from a business team and transform them into functional requirements

•          Ability to map source-to-target elements, design and develop transformation processes to load data from source to target, and develop and tune Informatica mappings and sessions

•          Extensive knowledge in performance tuning, surrogate key assignments and partitioning techniques

•          Understanding of Data Quality in OLTP systems and Business Intelligence environments

•          Complete working knowledge of SDLC lifecycle model

•          Understanding of change management and production support processes

•          Ability to prepare implementation and contingency plans for supported applications

•          Strong communication skills as well as ability to independently work with Business Analysts

•          Working knowledge of logical and physical data modeling techniques.

•          Working knowledge of data comparison and text editing tools like Exam-Diff, Beyond Compare and Edit

•          Experience with Windows / Linux automation scripting knowledge

•          Ability to be a team player and be pro-active,

•          Demonstrated ability to set weekly goals and deliver on them

 

Preferred qualifications:

•          Experience in Windows and Linux

•          Certifications in SQL server, Oracle and Informatica

•          Experience automating data validation processes in data conversion projects

•          Experience in Unix CRON scheduler or other scheduling tools knowledge

•          Experience with SharePoint desired

•          Experience with Microsoft Project

 

Behavior Characteristics:

Works under IT supervisor and business process owner. Independently plans, designs and carries out assignments in accordance with established policies and practices. Must work in a team. Must be able to learn quickly and work well under pressure.

 

Experience with and strong SQL querying knowledge of SQL Server 2005 and above

Required 6 Years 3 - Expert

 

Experience with and strong SQL querying knowledge of Oracle 10g and above

Required 6 Years 3 - Expert

 

 

Experience with performance tuning of long-running SQL queries using Oracle & SQL Server

Required 6 Years 2 - Proficient

 

Experience with Informatica 8.6.1 or 9.x.

Required 6 Years 2 - Proficient

 

Experience with Informatica Power Center - design, development, testing, and implementation of ETL jobs

Required 6 Years 3 - Expert

 

Experience with and working knowledge of ETL processes and Informatica Best Practices based on industry standards

Required 6 Years 2 - Proficient

 

Requirements gathering / analysis - creating functional requirements

Required 6 Years 2 - Proficient

 

Map source-to-target elements, design/develop transformation processes to load data from source to target, and develop/tune Informatica mappings

Required 6 Years 2 - Proficient

 

Extensive knowledge in performance tuning, surrogate key assignments and partitioning techniques

Required 6 Years 3 - Expert

 

Understanding of Data Quality in OLTP systems and Business Intelligence environments

Required 6 Years 2 - Proficient

 

Complete working knowledge of SDLC lifecycle model

Required 6 Years 2 - Proficient

 

Understanding of change management and production support processes

Required 6 Years 2 - Proficient

 

Experience preparing implementation and contingency plans for supported applications

Required 6 Years 2 - Proficient

 

Experience with logical and physical data modeling techniques

Required 3 Years 2 - Proficient

 

Experience with data comparison and text editing tools like Exam-Diff, Beyond Compare and Edit

Required 3 Years 2 - Proficient

 

Experience with Windows / Linux automation scripting knowledge

Required 6 Years 2 - Proficient

 

Experience in Windows and Linux

Desired 6 Years 2 - Proficient

 

Certifications in SQL server, Oracle and Informatica

Highly desired 6 Years 3 - Expert

 

Experience automating data validation processes in data conversion projects

Desired 6 Years 2 - Proficient

 

Experience in Unix CRON scheduler or other scheduling tools knowledge

Desired 3 Years 2 - Proficient

 

Experience with SharePoint desired

Desired 3 Years 2 - Proficient

 

Experience with Microsoft Project

Desired 3 Years 2 - Proficient