Arroju Srikanth

Etl Datastage Developer @Capgemini

Hyderabad, IN

Extracted and consolidated data from multiple sources to ensure seamless integration and improved data accessibility.• Designed and implemented data transformation rules and logic to meet business requirements, ensuring 100% data accuracy and consistency.• Developed and optimized loading processes to integrate transformed data into the target data warehouse, improving data load efficiency by 30%.• Implemented a robust error-handling mechanism to proactively identify and resolve issues during the ETL process, reducing errors by 25%.• Loaded and validated transformed data into the data warehouse, performing in-depth analysis to ensure integrity and accuracy.• Created comprehensive test cases and scenarios, covering data extraction, transformation, and loading processes to guarantee reliability.• Led data validation and testing efforts, including transformation testing, data loading testing, error handling testing, metadata validation, and regression testing, ensuring high-quality deliverables.• Developed custom SQL logic and generated insightful reports in Cognos Report Studio by analyzing data availability and business requirements.• Collaborated with Business Analysts (BAs) to gather and clarify requirements, ensuring alignment with business objectives and improving reporting accuracy.• Identified and resolved data issues through in-depth analysis and targeted code fixes, improving data quality and business decision-making.• Led Request for Change (RFC) efforts, implementing updates to Cognos reports and automating report scheduling to meet evolving business needs.• Coordinated data loading efforts into fact tables, adhering to business requirements and optimizing data processing times.• Utilized Dimensional Data Modeling techniques to meet business goals and improve data structure and reporting capabilities.• Implemented Unix shell scripts for pre/post-processing tasks, automating workflows and improving efficiency by 20%.

Malla Reddy Engineering College

Bachelor of Technology - BTech