ETL Programmer
MD - Baltimore
6 months

Madison Sterns, Inc., A National IT Consulting Firm, is currently looking for a experienced ETL Developer for a direct end customer in Baltimore, MD. Our client has a need for a specialized ETL developer with experience in higher education data, PK12 data, and/or work force data to participate in the definition of data requirements, definition of logical database data structures, and the definition of ETL workflow processes and programs. This position requires experience in data profiling, data de-duplication, data quality (edit rules and standardization), identity resolution, Extract, and transformation. Project duration is 6+ months. 

Duties / Responsibilities

1.   Analyze complex education accountability and performance reporting requirements with end users
2.   Prepare data models that support the creation of education data structures, KPI development, and ETL development in Informatica and
      Oracle 11g using ERWIN
3.   Develop complex ETL workflows
4.   Write ETL requirements and specifications documents
5.   Develop, test, and install ETL programs to maintain and transform data between various systems
6.   Develop Source To Target Mappings (STM)
7.   Perform data profiling as inputs to the STM design
8.   Develop Data Quality processes to improve data quality and provide Deterministic Identity Resolution
9.   Design and implement cross reference and lookup tables
10. Develop data lineage reports from the repository
11. Transform unstructured and poorly structured data into 3rd Normal Form tables with referential constraints
12. Aggregate and transform 3rd Normal Form data into multi-dimensional STAR schema Dimension and Fact table structures

Required Experience/Knowledge/Skill

Minimum of six (6) years of experience designing and developing data warehousing database star schemas, 3N data form databases using Oracle 10 g and 11g relational database management systems

Minimum of three (3) years of experience with the Oracle OWB- suite of tools, designing and  implementing ETL workflows

Minimum of six (6) years of experience programming in SQL and PL/SQL

Minimum of four (4) years of experience analyzing user requirements and translating them into system data structure designs and Source-To Target-Mappings (STM’s)

Minimum of two (2) years of experience installing and administrating an OWB-ETL application environment

Minimum of two (2) years of experience using ErWin design tools to create both logical and physical entity relationship (ER) diagrams

Minimum of one (1) year of experience working at a State or Local Education Agency

Would you like to apply to this job?

Apply for the ETL Programmer position