ETL Developer(Data Stage)

Dear Consultant

I hope you are doing well.

My name is Omkar Nath Sharma and I represent Synchrony Systems Inc. We are currently supporting an implementation partner on a full-time opportunity. Based on your background your experience may align well with this role.

Position Details:

Note:

• This role is not open for C2C/C2H/1099 or any contract arrangements
• This opportunity is available for candidates who can work on a full-time W2 basis without sponsorship.

Job Description

Must Have Technical/Functional Skills:

• We are seeking a ETL Developer with Extensive hands-on experience in IBM DataStage and IBM Cloud Pak for Data (CP4D)
• Need to have hands-on experience in designing developing optimizing and supporting enterprise-scale ETL solutions data integration pipelines and modernization initiatives involving migration from legacy DataStage environments to cloud-native data platforms.
• Should possess strong expertise in data warehousing data transformation performance optimization and production support while collaborating with cross-functional teams in an Agile delivery environment.

• IBM DataStage (11.x and above) Expert Level
• IBM Cloud Pak for Data (CP4D)
• ETL Design & Development
• Data Warehousing Concepts
• SQL (Advanced)
• Data Modeling
• Data Migration & Modernization
• Performance Tuning and Optimization
• Unix/Linux Shell Scripting

Preferred Skills

• Experience migrating ETL workloads from IBM DataStage to Cloud Pak for Data.
• Exposure to cloud-native architecture and enterprise modernization programs.
• Experience with Autosys Control-M or enterprise scheduling tools.
• Understanding of data governance metadata management and data lineage.
• Knowledge of DevOps and automated deployment pipelines for ETL applications.
• Exposure to Banking and Financial Services domain is highly preferred.
• Experience working in large-scale enterprise data platforms handling high-volume data processing.

Roles & Responsibilities:

• Design develop test and deploy ETL/Data Integration solutions using IBM DataStage (latest versions).
• Develop scalable and high-performance data pipelines for batch and near real-time processing.
• Lead migration and modernization initiatives from traditional DataStage environments to IBM Cloud Pak for Data (CP4D).
• Design and implement reusable ETL frameworks shared containers parameter sets and automation components.
• Perform complex data mapping transformation cleansing enrichment and validation activities.
• Conduct performance tuning and optimization of ETL jobs databases and data flows.
• Analyze production issues perform root-cause analysis and implement permanent fixes.
• Collaborate with Data Architects Business Analysts Product Owners and QA teams during solution design and delivery.
• Participate in Agile ceremonies including Sprint Planning Daily Standups Reviews and Retrospectives.
• Create and maintain technical design documents source-to-target mappings and operational runbooks.
• Ensure compliance with enterprise security governance and data quality standards.