SOWMYA CHINTHANIPPULA
Associate Consultant
Hyderabad
Summary
Dynamic IT professional with nearly 11 years of diverse experience in analyzing, developing, and implementing innovative business technology solutions. Expertise in data cleaning, building data pipelines, and conducting statistical analysis that enhance operational efficiency. A strong commitment to continuous growth in a data-driven environment complements exceptional problem-solving abilities and a passion for optimizing data workflows. Prepared to leverage a comprehensive skill set to contribute effectively to organizational success and foster transformative change.
Overview
13
13
years of professional experience
Work History
Associate Consultant
CGI (2017- 2021 , 2022 Aug to Till Date)
08.2022 - Current
- Designed and implemented data integrations from diverse sources including Kafka, RDBMS, and file systems using Redpoint Data Management (RPDM) ETL tool. Configured and optimized Slowly Changing Dimensions (SCD) of different types based on project requirements to ensure accurate data versioning and historical tracking.
- Designed and implemented end-to-end data pipelines in Snowflake, enabling seamless data integration, transformation, and delivery across multiple business domains.
- Designed and developed Databricks workspaces and notebooks to support the migration of data pipelines and transformations from Teradata to Databricks, ensuring performance optimization and data consistency.
- Leveraged AWS Glue to offload and optimize long-running queries from RPDM, significantly improving ETL performance and reducing execution time. Utilized AWS services including Glue, EC2, and S3 for scalable data processing, compute orchestration, and secure data storage.
- Orchestrated and automated end-to-end ETL workflows using Apache Airflow, improving process reliability, traceability, and execution efficiency across data pipelines.
- Developed and optimized Teradata BTEQ scripts to perform data extraction, transformation, and loading operations, ensuring data accuracy and performance efficiency.
- Designed and optimized data pipelines for the Evernorth Navigation project using Teradata RTIM and CIM UI, enhancing real-time decisioning and customer engagement capabilities.
- Managing and guiding a team of 6 engineers in executing Teradata-to-Databricks and Snowflake migration initiatives, overseeing design, development, and performance tuning for a seamless transition to modern cloud data platforms.
- Leveraged DevOps tools including Jenkins and Git to establish CI/CD pipelines, improving deployment efficiency, version control, and collaboration across development teams.
Manager
Capgemini
04.2022 - 08.2022
- Managed end-to-end ETL processes, including developing Teradata scripts, designing and implementing Informatica mappings, and scheduling and monitoring jobs with Control-M to ensure seamless data workflow.
- Maximized performance by monitoring daily activities and mentoring team members.
Lead Analyst
Virtusa
01.2021 - 12.2021
- Worked with emirates shipment related datasets, Our source legacy systems were using Cargo wise application is using SQL server databse.
- Migrating legacy systems from SQL server to Oracle using ODI ETL.
- Created Datamarts reports and shared the reports to Business for decision making.
- Worked on Informatica IICS workflows performance tuning.
Senior Software Engineer
Bank of America
01.2016 - 12.2017
- The Wholesale Credit Deep History project will create capabilities to store Deep History data sets on an established HDFS platform and allow data extraction from the WCP platform.
- Worked on Hadoop HDFS framework, oozie and spark for data loading.
- Worked on Informatica Power Center workflows.
Software Dev Associate
Dell International Services
01.2013 - 01.2016
- Developed Informatica mappings to implement integration activity for Integrating Different Sources like Oracle Tables, Flat File Extracts.
- Successfully collaborated with offshore and onsite teams to plan and execute the development of the project.
- Extracted data from Oracle Server Database tables and loaded into Teradata databases using Power Center.
- I have owned 60% ownership for this Project and delivered the Project on time.
- Deployed over 200 Informatica Objects, 615 Teradata objects, and 200 Control-M jobs without redeployments and was appreciated and awarded for my efforts.
- Loaded 1.1 TB of data which is very huge into the Teradata database through Informatica.
- Understand the source system to analyze the partitions, referential integrity and structure of the database.
- Design ETL to efficiently bring source data into target system.
- Develop and test ETL for accuracy.
- Coordinate SIT, UAT and Prod elevation.
- Worked with Teradata Utilities like BTEQ, MLOAD, FLOAD and TPT.
- Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
- Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data.
Education
Bachelor's degree - undefined
Jawaharlal Nehru Technological University
Skills
TERADATA
INFORMATICA PC and IICS
DATABRICKS
CICD Tools
SNOWFLAKE
SSIS
ODI
undefinedAccomplishments
- Michel Dell Award in 3 consecutive years (2014,2015,2016) - Dell International Services
- SnowPro Core Certification
- Silver award, 2020, CGI
- Silver award, 2024, CGI
Timeline
Associate Consultant
CGI (2017- 2021 , 2022 Aug to Till Date)
08.2022 - Current
Manager
Capgemini
04.2022 - 08.2022
Lead Analyst
Virtusa
01.2021 - 12.2021
Senior Software Engineer
Bank of America
01.2016 - 12.2017
Software Dev Associate
Dell International Services
01.2013 - 01.2016
Bachelor's degree - undefined
Jawaharlal Nehru Technological University