This site uses cookies. To find out more, see our Cookies Policy

ETL Datastage Developer in Charlotte, NC at AccruePartners

Date Posted: 12/2/2018

Job Snapshot

Job Description

AccruePartners values our contract and consulting employees. We offer a competitive benefits package to meet the diverse needs of all of our contractor and consulting employees and their family members. Here is a listing of what our company offers: 401(k) Medical, Dental, Vision, Life Insurance, Employee Assistance Program, Medical and Prescription Drug, Short and Long-Term Disability Insurance.

THE TEAM YOU WILL BE JOINING:

  • Fortune 100 Financial Services Company
  • 100-year history of dedication to customer satisfaction, success and growth
  • Tremendous growth and new business strategy leading to the need for new talent
  • Significant investments in cutting-edge technology

WHAT THEY OFFER YOU:

  • Culture: Excellent work environment that fosters collaboration
  • Growth: Ability to make an impact on the direction of the organization
  • Opportunity: Gain hands-on experience working with cutting-edge technology
  • Stability: Recent financial performance of the company has reported record profits

WHY THIS ROLE IS IMPORTANT:

  • Delivery of all ETL artifacts from the design to the delivery phase
  • 100% accountable for the quality of all ETL code
  • Work with business partners to ensure the business requirements are met for specific data integration projects throughout the organization
  • Responsible for Production Support and involved in On-Call for Data Integration applications

THE BACKGROUND THAT FITS:

  • Bachelor’s in Computer Science, CIS/MIS or equivalent degree
  • Expertise in Extraction, Cleansing, Validating and Integrating of data from multiple systems
  • Hands on experience in transforming business specific rules into functional Specs
  • Work with the Data Integration Architect to create ETL standards, High Level and Low-level design documents
  • Strong experience in designing Parallel, Server Jobs, Job Sequencers and Batch Jobs in DataStage 8.1.2 and 8.5
  • Strong experience in Informatica ETL including complex mappings, transformations and workflows.
  • Extensively worked with portioning for splitting multiple data streams into sub chunks to distribute the load evenly across all available processors to achieve maximum thru put.
  • Strong Knowledge of Data Warehouse Architecture, Star Schema, Snow flake Schema, Fact tables and Dimensional tables.
  • Experience in Integration of various data sources like TeraData, DB2UDB, SQL Server, Oracle, Sybase and MS-Access.
  • Strong experience in writing database procedures, functions and fine-tuning SQL for performance optimization.
  • Good experience in writing Shell Scripts to automate file manipulation and data loading procedures
  • Hands on experience in tuning mappings, identify and resolving performance bottlenecks in various levels like source and target mappings
  • Good Domain Knowledge in Finance and Asset Management
  • Excellent team player with good organizational, communicational, analytical and logical skills
  • 4-5 years of experience, including project management, application development, infrastructure selection and support, and systems technology analysis, with a heavy emphasis on DataStage and Informatica ETL