Previous Job
Previous
Senior DataStage ETL Developer
Ref No.: 18-48387
Location: Birmingham, Alabama
Start Date: 07/11/2018
 
Primary Responsibilities:
The Sr. ETL Analyst is responsible for transferring data from the legacy systems to centralized enterprise repositories.  The Sr. ETL Analyst may also be responsible for data validation, data cleansing, data transformation and calculations, as well as writing and scheduling the load jobs. The Sr. ETL Analyst must understand all the business rules currently existing in the legacy system and insure they are accounted for in the new system. The Sr. ETL Analyst should have excellent understanding of various business metadata. Assist with the research for any changes to existing ETL processes and handle the ETL functions for new projects.  The Sr. ETL Analyst is knowledgeable in Data Warehouse concepts such as master data management (MDM), operational data stores (ODS), data marts, fact tables and dimensions.
 
Additional responsibilities include:
· Design the system components for the extract/transform or conversion of data from source systems to the target application
· Design system components which reconcile and audit the results of the extract/transform or conversion of data from source systems to the target application
· Construct the extract/transform, transfer and audit components of the repositories mentioned earlier or data conversion programs through the use of extract development tools or custom developed procedures
· Define and manage the manual data load procedures
· Tuning and performance enhancements of queries and DataStage ETL
 
Summary of Qualifications:
1.       Bachelor degree, preferably in Computer Science, and five (5) years of programming experience or five (5) years of programming experience and three (3) years of relevant business experience
2.       Knowledge of programming languages, platforms, and data structures
3.       Minimum experience of 5 years with InfoSphere DataStage ETL development.  Additionally, working knowledge of other InfoSphere tools, specifically Quality Stage and Information Analyzer, is preferred.
4.       Minimum experience of 3 years with DB2 (preferred) or other relational DBMS, including table structure and relationships, and load utilities
5.       Ability to serve as a development lead on projects and mentor others
6.       Knowledge and use of Data Modeling techniques both logical and physical is preferred
7.       Excellent communication skills are required
8.       Experience with custom Unix scripts is preferred
9.       Experience with BASIC custom programming in DataStage is a plus
10.   Working knowledge of COBOL, DB2 and JCL on an IBM MVS mainframe is a plus
11.   Experience analyzing customer needs, designing new systems and/or modifying existing systems
12.   Healthcare industry experience will be a plus
13.   Ability to effectively prioritize and manage multiple concurrent projects
14.   Experience in a position interpreting and communicating information orally and written
15.   Experience in a position interacting with all levels of staff internal and external
16.   Experience in a position requiring the ability to identify and solve problems
17.   Experience in a position requiring the ability to organize and prioritize tasks
18.   Excellent experience and knowledge across multiple business applications and source systems is preferred