Design, develop, and implement ETL processes using IBM DataStage.
Analyze business and system requirements to create technical specifications and corresponding ETL solutions.
Develop and optimize parallel jobs using stages like Copy, Join, Merge, Lookup, Funnel, Filter, Sort, Remove Duplicates, Aggregator, and Transformer.
Import and process data from heterogeneous sources such as Oracle, SQL Server, and text files.
Conduct data validation, profiling, and ensure data quality and integrity across multiple sources.
Troubleshoot ETL issues in development, UAT, and production environments.
Collaborate with cross-functional teams including QA, business analysts, and database administrators.
Maintain documentation, including ETL designs, data mappings, workflows, and job specifications.
Optimize ETL performance and SQL scripts for better efficiency in data processing.
Stay updated on ETL best practices and emerging trends in data integration technologies
