Project description:
We are seeking an experienced DataStage ETL Engineer to design, develop, and execute high volume data migration pipelines that move legacy data into our up-to-date data warehouse and cloud platforms. The role will be part of the Data Migration Delivery Team, working closely with Business Analysts, Data Architects, and Infrastructure experts to ensure accurate, secure, and timely migration of critical financial and operational data.

Responsibilities:
Design and execute ETL jobs for WITT Data migration (Legacy system to Transact) using ETL tool

Data stage.

Work with Migration team, Business Analyst, Legacy team to provide Data mapping solutions in Data mapping workshops.

Design Data model/Data transformation jobs in Data stage and generate transformed file.

Perform data extraction from legacy core banking system, RDBMS, flat files or third-party systems.

Develop data transformation logic aligned with Transact data model and OFS standards.

Work efficiently as part of an international multi-disciplinary team to drive the project to completion.





Prepare migration strategy documents, mapping sheets and runbooks specific to ETL

Perform pre-migration and post migration data validations.

Prepare reconciliation reports by comparing record count, balances, financial totals and Identify & resolve data mismatches and defects.

Adhere to banking compliance, audit and security standards.

Provide production/L3 support for the delivered projects.

Contribute / review the technical specifications.

Responsible for managing & reporting technical risks.

Control and Maintain the quality of the developments (norms & standards, frameworks, source control, technical reviews, code reviews)

Work with L1/L2 support team in case of emergency production issues and provide support in fixing the production incidents.

Provide guidance to team members.

Skills:
Must have

Bachelor's degree in computer science, Information Systems, Engineering

5 + years of hands on exp

📌 Senior Datastage etl Developer (Chennai)
🏢 Luxoft
📍 Chennai