Etl Developer Scrum Master

Prasanth Burle

Cell: +1-913-***-****

Overland Park, KS

***************@*****.***

Summary of Experience:

7+ years of experience as a ETL developer with strong emphasis on in Data warehousing environment using ETL tools (IBM DataStage & Talend both), Unix Shell Scripting, Control M, Crontab, Talend TAC, SQL, and Azure SQLDatabase.

Team player, Motivated, able to grasp things quickly with analytical and problem-solvingskills.

Good knowledge of Data warehouse concepts, Star Schema, Snowflake, Dimension, Fact tables, and Modelling techniques.

Have a good understanding of AWSC Cloud (EC2, VPC, S3, Cloud watch, IAM, and Cloud Front) and AZURE concepts.

Exceptional background in analysis, design, development and testing of ETL components.

Proficient in source query optimization, ETL code performance tuning, reusable ETL code, complex transformations, and Automations.

Extensive experience in Extraction, Transformation, and Loading of data directly from heterogeneous source systems (Delimited, Excel, XML, JSON) including APIs and integration with Azure cloud

Demonstrated expertise on DataStage utilizing Transformer, Join, Change Capture, Join, Lookup, Merge, Dataset, Remove Duplicates, and Copy stages.

Extensively used Talend Open Studio - tmap, tjoin, tjava, tjavarow, tflowtoiterate, treplicate, treplace, tconextload, tbuffer, and trestclient.

Designed code with Error Handling, Restart ability, Header, Trailer validation, and Balancing Control.

Automated File system usage and Email notification on ETL jobs status using Shell scripting.

Expertise on Data migration projects for Talend and Datastage, also migrated SSIS packages, Oracle Stored Procedures,

Automated manual operations into ETL to reduce time and human error for faster reporting process.

Extensive Shell/Python scripting experience for Scheduling and Process Automation.

Exposure in ETL DevOps - GIT Hub, Talend CICD implementation, Nexus.

Scheduled jobs on Crontab, Control M, and Talend TAC.

Worked in SDLC & Agile methodologies Good Communication skills, Quick learner, and ability to accomplish deadlines.

Staying up to date with ETL development standards and best practices and applying the concepts in job design and construction. Self-documenting ETL Jobs to comply with Metadata standards.

Technology Skills

ETL Tools: IBM Data Stage, Talend, SSIS

DWH: Star Schema, Snowflake Schema, Dimensional Modelling

Languages/Scripting and others: SQL, Unix Shell Scripting, Crontab, Control M,TAC,Java, Python

Database: Netezza, MSQL Server, Oracle, DB2, SQL Server,MongoDB,TSQL

Devops: Agile, Service now, GIT Hub Repository and CICD implementation

Cloud Distributions: and AWS, EMR, EC2,S3 bucket, AWS CLI,DynamoDB

BigData Ecosystem: Spark, Hive, Mapreduce,Yarn,Sqoop,Pig

Educational Summary:

Bachelor of Engineering. Specialization: Computer Science and Engineering., AP, India.

Master’s in computers information science: University of Central Missouri MO, USA

Professional Experience:

Amex,AZ

Sep 2021 – Till date

ETL Engineer

Involved with Business Analysts to understand the business Requirement Specifications and implemented the ETL jobs using tools like Data Stage Talend.

Worked on the migration of IBM DataStage jobs to Talend tools

Involved the production support team to monitor the jobs of talend and DataStage

Worked on Service now tickets and ensure the production issues got resolved within the SLA.

Involved in the migration of ETL datastage jobs to talend jobs.

Developed quality check for source data/files using python and shell scripting (Header & Trailer validation & Balancing and Control)

Analyzed existing structure and created data model & mapping sheet.

Developed Audit for main frame source files (Header & Trailer validation & Balancing and Control).

Changed the data types using transformer stages.

Performance tuning - Using the tmap cache properties, Multi-threading and Parallelize components for better performance in case of huge source data.

Worked extensively on migrating on prem workloads to Azure Cloud.

Primarily responsible for fine-tuning long running sql queries and providing better solution to business.

Involved in creating Hive scripts for performing ad hoc data analysis required by the business teams

Mr. Cooper, Chennai

Feb 2019 – Jan 2021

Senior Software Engineer

Involved with Business Analysts to understand the business Requirement Specifications and implemented the ETL jobs using tools like Data Stage Talend.

Worked on the migration of IBM DataStage jobs to Talend tools

Involved the production support team to monitor the jobs of talend and DataStage

Worked on Service now tickets and ensure the production issues got resolved within the SLA.

Involved in the migration of ETL datastage jobs to talend jobs.

Developed quality check for source data/files using python and shell scripting (Header & Trailer validation & Balancing and Control)

Analyzed existing structure and created data model & mapping sheet.

Create automation with Unix scripting for basic file handling for issue analysis like presence of unstructured or control M character in input files, corrupt files, repetitive data analysis scenarios etc.

Performance tuning - Using the tmap cache properties, Multi-threading and Parallelize components for better performance in case of huge source data.

Worked extensively on migrating on prem workloads to Azure Cloud.

HCL technologies

USAA, Chennai

Dec 2017 – Jan2019

Senior Software Engineer

Analysis of XSD schema file to prepare the project plan

Coded ETL code to load the Source XML files data to target tables and developed the reusable

job to load the data in target tables

Creation of mapping sheet and Unit test cases

Developed the quality check by using Python script and SQL which includes from source to target.

Reported Daily and Weekly project status to Scrum Master.

Developed the sql queries to extract the data from different tables

Changed the data types using transformer stages.

Root cause analysis for the production issues and provided the permanent fixes wherever possible.

Developed several reusable parallel and sequence jobs that were used in other jobs.

Syntel

American Express, Chennai

Mar 2015– Nov 2017

ETL developer

Analyzed existing structure and created data model & mapping sheet.

Coded ETL code to load source files by handling (special characters), which are present in source files.

Developed Audit for main frame source files (Header & Trailer validation & Balancing and Control).

Developed reusable parallel and sequence jobs that were used in other jobs. Code reports domestic and international opt Blue Merchants though sources/targets are different.

Involved with Business Analysts to understand the business Requirement Specifications and implemented the ETL jobs using Data Stage.

Understanding of issues and impacts, proactive measures, and planning.

Mentor for junior resources in their analysis on production breaks to identify the bugs in the data/code.

Ensured the production issues got resolved within the SLA.

Reported Daily and Weekly project status to Scrum Master.

Performed coding and testing activities.

Project Documentation.

Contact this candidate