Etl Developer+ Data stage +ADF

Key Responsibilities:

• Extract data from various sources and ensure data consistency and completeness.
• Transform, clean, validate, and apply business rules to data for analytical use.
• Load transformed data into target systems and design efficient data models and workflows.
• Design, develop, implement, and maintain ETL processes and infrastructure using DataStage and ADF.
• Optimize ETL performance, monitor jobs, troubleshoot issues, and ensure data quality and compliance.
• Collaborate with stakeholders to gather data requirements and document ETL workflows.
• Develop DataStage sequencers and parallel jobs using stages such as Aggregator, Join, Merge, Lookup, Source dataset, External Filter, Row Generator, Column Generator, Change Capture, Copy, Funnel, Short, and Peek stages.
• Provide timely resolution for integration-related production issues and perform root cause analysis following change management procedures.
• Build, schedule, and monitor ADF pipelines, implement data flows, and manage data movement and transformations.
• Create and manage SQL Server Agent jobs, optimize SQL queries, and maintain SSIS packages for ETL operations.