Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Srikrishna Battula

ETL/Data Engineer
PLANO,TX

Summary

Data Engineer with over 10+ years of experience in analysis, design, modeling, development, implementation and testing of Data Warehousing. The ability to adapt and learn new technologies and proficient in learning them quickly.

Overview

10
10
years of professional experience
5
5
years of post-secondary education
1
1
Certification

Work History

Sr. ETL/Data Engineer

SGS Technologie LLC | Client: USAA
PLANO, TX
04.2018 - Current
  • Responsible for ETL (DataStage/Informatica) application program design, coding, unit testing, debugging and documentation.
  • Deploy ETL and DDL changes using CI/CD pipeline.
  • Very good knowledge of dbt, ability to develop models.
  • Developed HQL and scoop scripts to export from hadoop to Netezza work tables.
  • Contributed to internal activities for overall process improvements, efficiencies and innovation.
  • Executed test cases using qtest (testing tool).
  • Creating and Scheduling jobs on Control-M scheduler.

Sr. ETL/Data Engineer

SGS Technologie LLC | Client: Fifth Third Bank
Cincinnati, OH
04.2017 - 02.2018
  • Worked closely with Business Analysts to understand business rules and requirements in order to analyze and translate functional requirements into technical specifications to support the deployment of new subject areas.
  • Worked on performance tuning of ETL jobs using SQL queries, data connections, configuration files, parameter sets and environment variables.
  • Designed Error handling process and generated Error reports to be sent as email whenever a job was aborted.
  • Was involved in full integration testing of all the jobs within each sequence, before migrating to QA environment from development
  • Involved in code migration and code review sessions as part of migration plans.
  • Extensively worked on production support issues and resolved them on time and used e-mail task for capturing issues via e-mail along with the session logs.

Data Engineer

SGS Technologie LLC | Client: Albertsons/Safeway
San Francisco, CA
09.2016 - 03.2017
  • Developed ETL programs using DataStage to implement the business requirements.
  • Developed Complex Parallel Jobs using Connectors, Parallel stages like Sort, Lookup, Join, Filter, Aggregator, Transformer, Remove Duplicate etc.
  • Worked with various relational Databases Oracle, Teradata, and SQL server as source and target system for developing ETL Job components and debugging data issues.
  • Developed DataStage Sequences that include looping, restartability and check points.
  • Performed Unit Testing on the ETL components (Jobs/Scripts) make sure that they meet the design criteria and derive expected results
  • Utilized ds job commands for jobs Execution, report job logs and error handling through shell script.
  • Provided Technical support for production runs involving Monitoring jobs and fixing the issues.

Data Engineer

SGS Technologie LLC | Client: Macy’s
San Francisco, CA
10.2015 - 09.2016


  • Worked on the data stage code design and development as per the STMs in populating the database tables.
  • Developed Data Stage parallel jobs by using data from different sources formatted, Cleansed, summarized, aggregated and transform into data warehouse.
  • Worked extensively on different types of transformations Change capture, Modify, Stored procedure, Peek, Tail, Head, Sequence generator, Aggregator, Column Import, Column Export, Quality Stage, and FTP Stage.
  • Implemented Change data capture (CDC) to improve operational efficiency and saves time and resources by eliminating redundant data transfer.
  • Performance tuning of ETL jobs for optimum performance and Performed unit testing to the job that are developed and provided to support the code when is it in QA
  • Good experience in analyzing data using Hive.
  • Created UNIX scripts to automate ETL jobs and handle the file transfer and to process the ETL job based on the file availability.

ETL Developer

SGS Technologie LLC | Client: State Of Indiana
Indianapolis, IN
01.2012 - 09.2015


  • Used the DataStage designer to develop jobs to extract, transform and load data from Oracle/ SQL server database into the flat files and warehouse tables.
  • Designed, developed DataStage mappings, enabling the extract, transport and loading of the data into target tables.
  • Worked with Business Analyst to minimize the gap between the requirement gathering and code development.
  • Used Data Stage Sequencer as scheduler to schedule the Data Stage jobs.
  • Developed test scripts, test plan and test data.

Education

Master of Science - Information Technology

Sullivan University
Louisville, KY
06.2015 - 06.2016

Bachelor of Science - ECE (Electronics And Communications Engineering)

ICFAI Tech
India
06.2003 - 05.2007

Skills

Snowflake

undefined

Certification

IBM Certified Solution Developer in Info Sphere DataStage V9.1

Timeline

Sr. ETL/Data Engineer

SGS Technologie LLC | Client: USAA
04.2018 - Current

Sr. ETL/Data Engineer

SGS Technologie LLC | Client: Fifth Third Bank
04.2017 - 02.2018

Data Engineer

SGS Technologie LLC | Client: Albertsons/Safeway
09.2016 - 03.2017

Data Engineer

SGS Technologie LLC | Client: Macy’s
10.2015 - 09.2016

Master of Science - Information Technology

Sullivan University
06.2015 - 06.2016

ETL Developer

SGS Technologie LLC | Client: State Of Indiana
01.2012 - 09.2015

Bachelor of Science - ECE (Electronics And Communications Engineering)

ICFAI Tech
06.2003 - 05.2007

Similar Profiles

CREATE PROFILE
Srikrishna BattulaETL/Data Engineer