Data Integration Developer

Bank of America - Charlotte, NC3.9

Full-timeEstimated: $97,000 - $130,000 a year
Job Description:
Job Description:
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 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, Flat files into the target tables.

  • SQL, PL/SQL, Packages, Procedures, Functions and Triggers.
  • 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:
  • Fundamental knowledge of IT Service Management/ITIL processes and tools
  • Data Virtualization using Cisco’s Information Server (Composite)
  • Experience with Jira & Bitbucket
  • Cloudera Manager CDH Administration
  • ETL Tool - Syncsort DMX-h
  • Autosys and Oozie
  • Kafka
1st shift (United States of America)

Hours Per Week: