We provide IT Staff Augmentation Services!

Etl Developer Resume

SUMMARY

  • 4.9 years of proven ETL Developer and Sustainment Engineer.
  • Exposure to ETL tools like IBM Data Stage, SSIS and Optymyze (ETL cloud).
  • Experience in working on Oracle, SQL Server and Teradata DB.
  • Expertise in UNIX shell scripting, SQL, PL/SQL, Informatica and Teradata production support, sustainment and development.
  • Experience in working on Callidus ETL and Data Integration.
  • Extensively worked on data extraction, Transformation and loading from various sources like Oracle, Flat files etc.
  • Solid Expertise in Oracle Stored Procedures, Triggers, Index, Table Partitions and experienced in Loading data like Flat Files, XML Files, Oracle into Data Warehouse/Data Marts using Informatica.
  • Proficient in coding of optimized Teradata batch processing scripts for data transformation, aggregation and load using BTEQ.
  • Expertise in RDBMS, database Normalization and Denormalization concepts and principles.
  • Strong experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Teradata.
  • Strong skills in debugging Teradata utilities like Fast Load, Fast Export, MultiLoad and Tpump for Teradata ETL processing huge volumes of data throughput.
  • Sound Knowledge of Data Warehousing concepts, E - R model&Dimensional modeling(3NF) like Star Schema, Snowflake Schema and database architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
  • Sound knowledge and hands on experience in ETL concepts and logics.
  • Strong experience with ETL tool Informatica 8.5/9.6.
  • Created mapping documents,work flows and data dictionaries.
  • Good knowledge of Data Warehouse concepts and principles - Star Schema, Snowflake, SCD, Surrogate Keys, Normalization/ De-normalization.
  • Quick adaptability to new technologies and zeal to improve technical skills.
  • Good analytical, programming, problem solving and troubleshooting skills.
  • Basic knowledge on Python programming for data analysis.
  • Basic knowledge on Machine learning concepts and Data engineering.
  • Basic knowledge on Data structures and Data models.
  • Good knowledge on the Data flow from raw form till the form in Operations perspective.

TECHNICAL SKILLS

Operating System: UNIX,LINUX, Microsoft Office 2003/XP/2007/2016.

Database: Teradata, Oracle, Vertica, MS SQL.

Languages: SQL, Teradata SQL, basic knowledge on VSQL, C,Java, PL/SQL,.

Web Technology: Basic knowledge on HTML, J2EE.

ETL Tools/Techs: Informatica 8.5/9.6.1., SSIS(basic knowledge)

Schedulers: Tiwoli workload scheduler (UNIX and LINUX).

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

  • As an ETL SME, gathering requirements from client as per the business.
  • Analysing the requirements.
  • Migration of the objects of application, Callidus DLM to cloud based Optymyze DLM.
  • Migrating ETL(Informatica based) application to cloud based ETL application.
  • Re-creating all the transformations with the added logics as per business requirements.
  • Developing and deploying new codes into production.
  • Working on automating some of the processes to reduce manual work using shell scripting.
  • Developing ETL objects using Informatica to maintain dealer details in Optymyze.
  • Working on Triggers and Stored procedures to generate continuous alerts.
  • Migrating part of the previous data into new environment using SQL/PLSQL blocks.
  • Testing the developed scripts for given inputs and retrieved results.
  • Developing, Testing and deploying into production environment.
  • Monitoring the environment 24*7.
  • Fixing the productions issues.
  • Working on change requests for deploying new/updated code.
  • Providing permanent fixes for production issues.
  • Working on client reports.
  • Building Transformation logics for Incentive and payout calculations.
  • Building complex transformations as per the requirements and making sure huge amounts of data is being loaded into cloud.
  • Strong usage of stats for payout calculations of the end user.

Confidential

ETL Developer

Responsibilities:

  • As an ETL consultant, we integrate data from different sources including DWH applications.
  • We create ETL objects using Informatica as per the business requirements.
  • We create unix shell scripts which have Informatica runtime configurations to load data into stage tables.
  • We create/run pipelines in callidus to load data into Callidus “Truecomp DB”.
  • After data is loaded into “Truecomp DB”, using the Truecomp Manager and with set of rules incentives for dealers is calculated.
  • After calculating the dealer incentives, depending on the business indications and different types of dealer’s payouts are calculated for respective months.
  • Generate payment reports and different types of reports and publish to respective teams.
  • Developing and deploying new codes into production as per changes and requirements.
  • Working on automating some of the processes to reduce manual work using shell scripting.
  • Usage of Triggers and Stored procedures as per requirements using PL-SQL..
  • Developing, Testing and deploying into production environment.
  • Monitoring the environment 24*7.
  • Fixing the productions issues.
  • Working on change requests for deploying new/updated code.
  • Providing permanent fixes for production issues.

Confidential

ETL Sustainment/Developer

Responsibilities:

  • Monitoring the workflows by using Informatica workflow Monitor, Teradata sessions in the Teradata viewpoint and jobs through the TWS Scheduler.
  • Worked on the Teradata stored procedures and functions to confirm the data and have load it on the table.
  • Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
  • Worked on optimizing and tuning the Teradata views and SQL’s to improve the performance of batch and response time of data for users.
  • Worked closely with analysts to come up with detailed solution approach design documents.
  • Proposing and promoting query and design changes as per the production requirement.
  • Identifying the root cause of the issues and providing a permanent solution.
  • Analysing the data flow and identifying the root cause to the data issue and providing fix.
  • Working on client requests such as data correction and data validation on priority.
  • Supporting the applications during any outage window.
  • Working on Change Request's as per the business requirement.
  • Checking upstream and downstream systems availability and sending timely updates.
  • Rigorous check on the files availability Confidential landing directory/staging area.
  • Informing the Business for any delay of data and production outage.
  • Preparing the reports based on the business request on Hourly, Daily, weekly, Monthly and Ad-hoc basis.
  • Automation for monitoring TWS objects failures.
  • Cleaning of the file system disk space before reaching the mount point size 100% on Unix and Linux servers.
  • Continuous check on the performance of Application servers, source DB and Target DB's.
  • Leading the team and helping them in problem solving as a duty manager.
  • Hosting the Internal and client calls.

Hire Now