ETL Designer in Westchester, PA

Position: ETL Designer
Location: Westchester, PA
Type of hire: Contract

JD
Technical/Functional Skills
• 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
• 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.
• Assist other junior ETL resources with the proper usage of ETL tools and techniques as per defined ETL standards, development guidelines and best Practices.
• Provide regular feedback to architecture team on existing design patterns for enhancements.
• 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.
• Works with data stewards to ensure the integration solution meets data delivery and quality SLAs
• 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
• In depth knowledge on Data Warehousing, data modeling
• Hands on experience on data modeling, high level design and low level design
• Experience in big data platform/Hadoop development
• Experience in RDBMS – Teradata/Oracle
• Knowledge in Data profiling

Experience Required 8 Yrs +

Roles & 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
• 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.
• Assist other junior ETL resources with the proper usage of ETL tools and techniques as per defined ETL standards, development guidelines and best Practices.
• Provide regular feedback to architecture team on existing design patterns for enhancements.
• 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.
• Works with data stewards to ensure the integration solution meets data delivery and quality SLAs
• 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
• In depth knowledge on Data Warehousing, data modeling
• Hands on experience on data modeling, high level design and low level design
• Experience in big data platform/Hadoop development
• Experience in RDBMS – Teradata/Oracle
• Knowledge in Data profiling

Email: sunil.a@idctechnologies.com