Previous Job
Previous
ETL Developer
Ref No.: 19-01144
Location: Milwaukee, Wisconsin
Position: ETL Developer
Location: Milwaukee, WI.
Duration: 7 months Contract
Mode of Interview: Phone and Webex


Job Description:

Key Responsibilities:
  • Analyzes Project-specific business requirements and system integration points to design appropriate ETL solutions that are aligned with Architectural standards.
  • Responsible for delivery of the design, code, testing and documentation, based on system and technical requirements
  • Responsible for impact analysis in case an existing object is modified
  • Works with solution architects to choose a data integration style to meet the needs of each project — for example, replication, ETL, views, etc.
  • Engages with Business SME's to understand the use cases that the integration solution must support.
  • Presents ETL design in Architectural review meeting comprising of Solution Architects/ETL Architects/Data Architects/DBA/Engineers/Testing Team.
  • Works with the Project Data Modeler in understanding the Entity relationships also hands over ETL Architecture design documents to the Development team(s).
  • Interacts with database administrators to meet requirements for volume and performance.
  • During the execution of each phase, assumes an active project role and supports ETL team during development, testing and implementation rollout.
  • ETL Architecture Design Artifacts as part of Application Design Document (ADD)
    • High Level End-to-End data flow diagram
    • ETL Functional Specification, with Transformation Logic
    • Process Dependencies
  • Data mappings and transformation processes
  • Job Schedules and Automation for extraction and load processes
Experience & Qualifications:
  • Experience in T-SQL, and ETL capabilities –Informatica, SQL Server, Teradata
  • Understanding of Informatica's repository tables
  • Understanding of Database's system tables
  • Understanding of source and target data structures and relationships
  • Experience with Data modeling – ERWin experience is beneficial
  • Strong performance-tuning, problems-solving and analytical skills