ETL Developer Resume

SUMMARY

Proficient In business understanding of verticals like wholesale Banking, retail banking and consumer lending.
Having 8+ years of experience in designing and implementing Data Warehouse and Data mart applications, mainly in understanding and developing ETL processes using Informatica, Oracle Data Integrator and PL/SQL.
Over 8 years of experience in designing and deployment/ scheduling Autosys Jobs.
Strong Experience and knowledge in Oracle, MS SQL Server 2008 and Green Plum Database.
Proficient in writing SQL, PL/SQL queries, and involved in performance tuning for large complex queries, and experienced UNIX and Shell Scripting for automation.
Very good understanding of Data Warehousing concepts and dimensional modeling technique.
Involved in activities such as production simulation, production deployment and defect fixing in all environments.
Hand on experience in production warranty support after deployment of code in production.
Good communication, collaboration and interpersonal skills with very sharp learning curve.
Currently Getting Acquiring Hands - on Experience on Machine Learning development using Python by educational websites like Kaggle.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Environment: Informatica, Ab initio, Oracle 12c, Teradata, UNIX, Autosys

ETL Developer

Responsibilities:

Closely worked with Data Analyst / Business Analyst to understand business requirement for ETL Design.
Analyzed source files/tables types and proceeding for setting up the environment for extract transform and load the data which includes creation of folder in Informatica, Unix Directory creations, estimating size and sub- directories required for project deliverables.
ETL designs and implementation for loading data into database.
Involved in performance tuning Activities if data loading takes time more than usual.
Involved in Data validation and System integration or Unit testing as per business requirement to ensure the consistent data and full functionality of code.
Worked on continuous enhancement of Metadata based ETL/DB functionality to enrich the features and performance while minimizing the complexity
Keep on track for Defect Raised by the quality analysis team and fix the data if raised.
Documentation for implementation of code into production.
Raised the change request if changes require in production using JIRA tool.
Participated in Warranty support activities and resolved the issue if any.
Estimate the efforts for Iteration Cycle for task of each team member.
Make sure should be delivered on timely basis for 15 days Iteration Cycle.
Presenting Daily calls to Onsite/Offshore coordinators and team members for work progress/updates.
Ensure best Onshore/Offshore Coordination for our stream and get/provide updates for daily task activities.

Confidential

Environment: Oracle Data Integrator 11g, Oracle 11g, UNIX

ETL Developer

Responsibilities:

Worked in this project as ETL Developer.
Developing mappings and packages to Dimensions and Facts from different source systems and unit testing the same.
Developing Shell Scripts for running jobs in Unix/Linux servers and automating the scripts to run multiple jobs in parallel.
Implementing complex logic that includes calculating interest rates, running balances, MTD, QTD, YTD calculations.
Performing historical loads, daily batch loads, Day 0 for production environment loads that includes millions of data from previous system.
Performance tuning for Dimensions and Facts tables that has complex logic involving several level of joining datasets.
Working closely with data modelers to implement business logic.
Testing the packages to check the consistency of data in different tables.
Providing defect fixing for testing on time.
Working with other teams on which ETL team depend & teams who are depended on ETL team.
Provide knowledge to support team/ new joiners for Process flow.
Involved in Production Support activities during warranty period.
Working in Oracle Data Integrator, Toad to do all these jobs.

Confidential

Environment: Informatica, Oracle 11g, PostgreSQL, UNIX

ETL Developer

Responsibilities:

Worked in this project as ETL Developer.
Understanding the requirement for ETLs and database logics based on the business requirement document.
Check for the source files/tables types and proceeding for setting up the environment for extract transform and load the data which includes creation of folder in informatica, Unix Directory creations, estimating size and sub- directories required for project deliverables.
ETL designs and implementation for loading data into database.
Automate the loading process through Autosys jobs and create UNIX shell script also if required.
Involved in performance tuning Activities if data loading takes time more than usual.
Data validation and Unit testing as per business requirement to ensure the consistent data.
Keep tracking defect raised by the quality analysis team and fix it if any.
Documentation for implementation of code into production.
Raised the change request if changes requires in production using Hewett-Packard Service Manager tool.
Provide knowledge to support team/ new joiners for Process flow.
Coordinate with other team e.g. Informatica Admin/Database Administrator for Various issues like Migration/Access Issues.
Presenting Daily calls to Onsite coordinators and offshore team members for work progress/updates.