Etl Developer

Soumya G

Aldie • linkedin.com/in/soumya-gankidi-*0b0a71b3

*************@*****.*** • 404-***-****

ETL Developer

ETL and Data Integration professional with 8+ years of experience designing and developing robust pipelines using Snowflake, Talend, Python, SSIS, and ODI 12C. Proficient in SQL, PL/SQL, and database technologies for data extraction, transformation, and loading. Skilled in Agile methodologies, SDLC, and performance tuning. Strong problem-solving, teamwork, and time management skills. Experienced in 24x7 environments and user acceptance testing (UAT) WORK EXPERIENCE

One Call Care Management System • Jacksonville, FL • 01/2021 - Present ETL Developer Facilitated cross-team collaboration to migrate SSRS reports and OLAP cubes to Snowflake, resulting in improved data accessibility and performance without any downtime.

•

Transformed complex SQL scripts into efficient queries, significantly improving data processing speed and reducing system load, enhancing overall performance.

•

Streamlined the migration of SQL Server database objects to Snowflake, achieving a 25% reduction in downtime while maintaining data integrity and business continuity.

•

Created a robust framework for virtualized data access, significantly improving data retrieval times and supporting strategic decision-making across teams.

•

Designed and developed ETL pipelines using Talend, automating data ingestion, transformation, and validation, ensuring seamless integration across systems

•

Built reusable Talend jobs to standardize data processing, reducing development time and improving maintainability.

•

Leveraged Python for ETL automation, developing scripts for data extraction, transformation, and validation, reducing manual intervention and improving efficiency.

•

Built complex ETL workflows to integrate structured and unstructured data from RDBMS, XML, CSV, and flat files.

•

Optimized ETL jobs and database queries, improving data processing speed and reducing system load.

•

Diagnosed and resolved complex data pipeline performance issues, ensuring efficient and error- free execution.

•

Monitored automated data loads, proactively addressing failures and ensuring timely execution with minimal downtime.

•

Collaborated with cross-functional teams to translate business requirements into scalable ETL and data integration solutions.

•

Participated in all phases of the SDLC, including requirement gathering, solution design, technical walkthroughs, and deployment.

•

Candid Source (ACI Worldwide Inc.) • Chantilly, VA • 12/2019 - 10/2020 ODI Developer

K12 Inc • Herndon • 06/2017 - 05/2019

ETL Developer Developed and optimized ETL workflows using ODI and Talend, achieving a 30% reduction in processing time while ensuring data accuracy.

•

• Worked in Agile Methodology.

• Closely work with Architects and users to gather requirements from the users.

• Analyze source data set using SQL to gather and validate requirements. Developed quick POC solutions for the requirements before the actual full-scale implementations using Talend.

•

Designed and built ODI load plans and scenarios, ODI interfaces, variables, and packages to support the actual data loads.

•

• Develop Tableau reports and Dashboards as per user requirements.

• Performed Integration, End-to-End system testing.

• Involved in Functional Testing & Regression Testing

• Worked in writing complex SQL queries to verify data from Source to Target.

• Performed data validation testing writing SQL queries.

• Installed ODI and set up the ODI connection with Oracle, MS SQL Server, and flat files.

• Worked in Agile Methodology.

• Interacted with business users to understand their requirements.

• Created new models for the data sources like flat files, MS SQL server, Oracle.

• Developed Tableau Reports for K12 School Attendance and Grades.

• Did reverse engineering for the data sources and targets. Worked with multiple sources such as Relational databases, Flat files like CSV, Txt for Extraction, Transforming and Loading data into target tables.

•

• Monitored the Execution Logs in operator navigator.

• Worked on loading metadata from flat file source system into target systems using SQL Loader. Programmed packages, stored procedures, Functions, Sequences and SQL queries on Oracle SQL developer.

•

• Worked on Yammer implementation and documented user guidelines for the team. Worked closely with the end users and designed the documents to the track changes through JIRA.

•

Worked with Microsoft Excel to include using pivot tables and functions like VLOOKUP, averages and other Excel function.

•

• Involved in Database performance tuning and Implementation.

• Performed unit and system testing.

• Planned and supervised the daily activities of the application support. Involved in fixing bugs for the applications and ensured all support service level agreements are met.

•

Candid Source (Garmin) • Kansas City • 01/2016 - 05/2017 ODI Developer

EDUCATION

Master of Science in Information Technology

Hood College • Hood College, MD

SKILLS

Agile Methodology, Azure Data Factory, Azure Data Studio, Business Logic, Data Integration, ETL, Excel, GIT, HVR, Kanban, MS Office Productivity Tools, MS SQL Server, OBIEE, ODI 12C, Oracle, Oracle Data Integrator 11g, Oracle SQL Developer, Organization, PL/SQL, Power BI, PowerPoint, Problem-Solving, Programming, Python, Reporting, Scripting Languages, SharePoint, Snowflake, Software Development Life Cycle (SDLC), SQL, SQL Server Management Studio, SSIS, SSRS, SVN, Tableau, Talend 7.3.1, Time Management, Version Control, Visio, Visual Studio, Word

• Interacted with Business Personnel to gather, analyze and develop the requirements.

• Involved in all phases of ETL from design to development, implementation, testing and support.

• Developed ETL Mappings and Workflows using Informatica. Developed cloud integrations with ETL Tools using SOAP and REST Calls with Oracle Fusion Cloud and 3rd party revenue and billing systems.

•

• Used ODI 11g/12c for extraction, loading and transformation ELT of data in the data warehouse. Designed and built ODI load plans and scenarios, ODI interfaces, variables and packages to support the actual data loads.

•

• Worked in creating model, sub-model, reverse-engineering model and created mapping objects.

• Scheduled ODI jobs using ODI scheduler.

• Worked on ODI 11G to ODI 12C DEV environment upgrade. Working on Batch Audit Report and sending the report to users which shows discrepancies between source and Target data and fixed the audit code using SSIS, tested and deployed SSIS packages.

•

Written SQL Queries, Procedures, Functions for an automation project that helps to do impact assessment on code based in a more automated fashion that is driven via metadata.

•

• Involved in performance Tuning of SQL queries using Oracle hints and indexes.

• Worked on SVN code versioning product implementation.

• Performed Unit and System testing and worked with QA and Supported until UAT is done.

• Performed required maintenance on the data warehouse.

• Monitored daily production Loads to reach under SLA (Service Level Agreement)

Contact this candidate