ETL Developer (Closed)

SkillStorm is seeking an ETL Developer for our client in Charlotte, North Carolina. Candidates must be able to work on SkillStorm's W2; not a C2C position. EOE, including disability/vets.

Job Description:

• Leads and/or participates in the design, development, and implementation of complex system engineering activities involving cross-functional technical support, systems programming and data center capabilities. Responsible for components of highly complex engineering and/or analytical tasks and activities. Establishes input/output processes and working parameters for hardware/software compatibility, coordination of subsystems design, and integration of total system. Viewed as a technology subject matter expert; able to provide and communicate complex technology solutions across differing audiences including technical, managerial, business executives, and/or vendors. Will have responsibility for multiple, complex projects; will direct activities of teams related to special initiatives or operations and may have direct reports. Leads the resolution process for complex problems where analysis of situations or data requires an in-depth evaluation of various factors. Exercises judgment within broadly defined practices and policies in selecting methods, techniques, and evaluation criterion for obtaining results. Information Technology degree and/or technology certifications preferred or substantial equivalent experience. Typically 5-7 years of IT experience.
• Analyze source data/file structures, technical metadata, profile source data and develop data mapping and transformation rules and detail ETL specifications based on business requirements;
• Assist in the collection of technical metadata supporting the implementation;
• Utilize automation tools to schedule, execute, and monitor ETL jobs;
• Design, test, and debug data flow plans to create necessary Client files and/or populated databases;
• Design of the ETL application.
• Performance tune the application to meet operational production requirements;
• Develop and execute, in conjunction with the ETL Architect, Quality and Release, and Process Analyst system and integration test plans;
• Responsible for data migration from legacy system to new Platform
• Design and develop ETL jobs and sequences
• Design and develop multiple reports including audit, error and reconciliation reports.
• Candidate must have understanding of ETL Processes and Best Practices
• Expert level knowledge and hands-on experience with IBM DataStage Enterprise Edition/Parallel Extender (Orchestrate) for parallel processing as part of ETL conversion process integrating multiple source

Required Skills:

• Integration of various data sources like Oracle, DB2, DB2UDB, SQL Server, API’s and Flat files into the target tables. 
• SQL, PL/SQL
• Performance Tuning of SQL statements, stored procedures, and functions.
• Writing UNIX shell scripts as per the requirement and used Job scheduling tools like Autosys utility
• Firm understanding of software development Lifecycle, release management and change management process
• 5+ years of experience in Production Support. Strong analytical, diagnostic, and troubleshooting skills and ability to work in a dynamic, team-oriented environment.
• Strong written and verbal communication skills
• Understanding and hands-on experience with XML packages in DataStage
• Diverse understanding of IT infrastructure and other technologies is a plus
• Strong written and verbal communication skills
• Team player and self-motivated, work independently with minimum direction

Desired Skills:

• Apache Nifi & Confluent Kafka
• Fundamental knowledge of IT Service Management/ITIL processes and tools
• Data Virtualization using Presto/Trino
• Experience with Jira & Bitbucket
• Autosys and Oozie

#LI-DNI