DATASATGE DEVELOPER
Tata Consultancy Services
- 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