Sign in

ETL Developer

United States
August 30, 2018

Contact this candidate





●Performance-driven, industrious, and seasoned SQL/ETL Developer with 8 years experience inData Analysis and Reporting, Dimensional Modeling, and Data Warehouse design and implementation using SQL Server, Oracle and TeraData

●8 years comprehensive professional experience in Data Base Design, Data Warehousing, ETL (Extraction, Transformation, Loading) using Informatica PowerCenter 8.6.x/9.0.x/9.1/9.5.x/9.6.x/10.1

●Experience in creating the mapping, assigning workflow, testing the flow and monitoring the job

●Experience in creating Sessions, Workflows, and Worklets by using the Workflow Manager tools like Task Developer, Worklet and Workflow Designer

●Experience with complex mappings using Filter, Aggregator, Expression, Router, Joiner, Lookup, Update Strategy, Sequence generator, XML Source Qualifier, Rank

●Created mappings in Informatica Data Quality (IDQ) using parser, standardizer and address validator transformations

●Expert in designing and developing efficient ETL solutions to load huge volumes of data to/from various Flat files, XML files and Relational Databases i.e. Teradata, Oracle, SQL Server.

●Experience in Erwin Database programming for Data Warehouses (Schemas), proficient in Logical and Physical Database design, dimensional modeling, Star Schema, Snowflake and Hierarchy modeling.

●In-depth knowledge of SQL, and PL/SQL programming, Python, and Unix shell scripting

●Experienced with reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, calculated fields, Sets, Groups, Actions, Parameter's etc., in Tableau.

●Ability to read and parse JSON in Python and Tableau for Data Analysis and visualization

●Expertise in importing Data files into Python and using Python for Data visualization projects

●Proficiency in Unix commands and file management in the Unix environment

●Working knowledge of InformaticaPowerCenter 9.6 for ETL projects and Informatica Data Quality (IDQ V 10) for data profiling and data cleansing projects

●Knowledge working with different data sources such as flat files, JSON files, XML, Excel, Oracle, and SQL Server

●Knowledgeable in VBA Macros in Excel for reports creation and data analysis

●Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors

●Thorough understanding of both Waterfall & Agile methodologies including SCRUM

●Extensive database experience and highly skilled in SQL in Oracle, MSSQL Server, DB2, Teradata, Sybase, Flat Files, CSV files, MS Access.

●Knowledge in creating drill-through reports, lists reports, crosstab reports and different charts using Tableau

●Excellent problem-solving skills and good interpersonal skills. Quick learner and excellent team player, ability to meet tight deadlines and work under pressure

Education & Training

Bachelor’s in Business Management

Major: Banking and Finance

Technical Skills

ETL Tools: Informatica (Power Center 10x/9X//8x)

Operating Systems: Windows server 2012, Ubuntu Server 18.04, Red Hat Linux 7.2/7.3

RDBMS: Oracle7/ 8i/9i /10g, MS-Access 2002/2003, SQL Server 2014, DB2

Data Base Tools: Toad, SQL Navigator 4.0, SQL Loader

Data Modeling: Erwin

Reporting tools: Tableau 9.2/9.3/10.0, Cognos, MS Excel

Scripting: Unix Shell Scripting

Languages: HTML, PL/SQL, Python, JSON, VBA

Work Experience

AMAZON FC – FTW6 & DFW7 Coppell, Texas

ICQA ETL Developer and Data Analyst (April 2017 –To Date)

This is a position with the Inventory Control, Quality Assurance (ICQA) department that involved providing Collection, Cleansing, Integration, and analytical support for root cause investigation of defects, and ensure compliance to ICQA-related requirements.


Development of data collection processes and data management systems

Maintenance of data integrity (0% error rate)

Designing of queries, compiling of data, and generation of reports using VBA MS Access and Excel

Charting and graphing of data for reporting purposes

In depth research of defect trends

Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica power center 9.5

Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data.

Effective coding with Creation of mapplets and reusable stored procedures

Used Informatica IDQ Normalizer transformation for effectively capturing multiple errors in feed files thus ensuring excellent data quality

Data mining, defect analysis, resolution, tracking, and general data flow problem solving

Present analysis in easily digestible standard reports

Participated in weekly end user meetings to discuss data quality, performance issues, ways to improve data accuracy and requirements gathering, and line of business in understanding the high-level requirements etc

In-depth analysis and designing of parent and child referential integrity

Designed end to end Data Flow model using Toad data Modeler

Documenting Root Cause Analysis (RCA) reports and lesson learnt for avoiding similar

error/bugs in next releases

Back up for Process Assistant duties


ETL developer (April 2015– March 2017)

This Project involved creating Data Marts and Data Warehouse for sales Analysis and Reporting system, Extraction of Data from ODS (operational data source), transforming and loading into the data warehouse using Informatica. The project supported Business Objects applications.


Standardize data from heterogeneous sources such as Oracle, SQL Server, and DB2 from an AS/400 and load into Data Staging area

Developing various Mappings and Transformations using Informatica Designer

Used Mapping designer and Mapplets to generate different mappings for different loads

Used Server Manager to schedule and monitor different sessions of loading

Used the PL/SQL procedures for data extraction, transformation and loading

Performance Tuning of sources, targets, mappings and SQL queries in transformations

Created various transformations like Joiner, Aggregate, Expression, Filter, update Strategy

Carried out precise documentation of all mappings, workflows and reports

Performed Relational Data Modeling, ER Diagrams (forward & reverse engineering), dimensional modeling, OLAP multidimensional Cube design & analysis, define slowly changing dimensions and surrogate key management


Informatica ETL Developer (December 2013 – March 2015)

The main objective of the project was to help the decision-making team of the organization, to monitor and improve the sales and to explore avenues for new business opportunities. The DW team was responsible for building and maintaining the Enterprise Data Warehouse and providing reports for Production and Midstream groups.


Involved in preparation and analysis of Functional HLD requirements and development of LLD artifacts for ETL

Development of mappings, workflows, session and tasks using Informatica power center

Examining the session logs in case of workflows failures and debugging mappings using Debugger tool in Mapping Designer

Participated in testing Data matching between source to target Databases

Worked on transformations like Lookup, Sequence Generator, Filter, Transformation etc

Involved in Data loading to staging tables and from staging tables to Target tables i.e. Data loading from source to target Database

Testing the codes and deploying it to the QA environment for UAT

Perform system and requirement analysis, coding, unit testing of load into EDW

Implemented a new methodology in the form of dashboard using Informatica and unix to determine a process or a job run status and stats

Configuring BMC Control M scheduler to execute the ETL workflows and monitoring daily ETL data load

Involved in Informatica Mappings migration from development, testing, to production

Involved in mock deployment activity prior to the main release activity where the code is migrated to new environment


ETL Developer (May 2011 – November 2013)

This project involved migration of mapping from Informatica version 8.6 to Informatica version 9.1, Error handler and sending email to Lotus Notes distribution on execution error. Removing the detail of the persons who are no longer with the company and have TrackWise account stored into the Flat files for COE management.

Examining the session logs in case of workflows failures and debugging mappings using Debugger tool in Mapping Designer

Extensive experience in using ETL process using Informatica Power Center 8.6/ 9.1

Participated in exporting the sources, targets, mappings, workflows, tasks etc. and importing them into the new Informatica 9.1 platform

Developed the Mappings using needed Transformations in Informatica tool according to technical specifications

Tested and reviewed imported Informatica objects to make sure that all the workflows are Execute as per the Design documents and Tech specification

Created/modified various Informatica Mappings and workflows for the successful migration of the data from various source systems to Oracle that met business requirements for reporting and analysis

Extensively used XML Source, XML target and XML Parser transformations

Imported Source and Target tables from their respective databases

Used Informatica Designer to develop Mapplets and Transformations for migration of data from existing systems to the new system

Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalize, Joiner, Update Strategy, Rank, Aggregator, Sorter

Interacted with the off-shore ETL and Database teams

Prepared Documentation material for the mapping according to the designed logic used in the mapping


ETL Developer (April 2010 –May 2011)

A full-service research company providing the pan African market with suitable information solutions required to sustain the ever-growing economies in the continent


Primarily responsible to convert business requirementsinto system design

Further implemented system model in Informatica, comprehensively using the functionality of the tool

Used ETL to standardize data from various sources and load into Data Stage area

Used several transformations like source qualifier, expression, lookup, aggregator, Joiner, sequence generator, router and update strategy transformations for complex mappings

Designed and developed catalogs that reflected business view of the data to enable other developers to design cubes and reports

Extensively used PL/SQLProcedures/Functions to build business rules

Extensively worked in the performance tuning of Developed Mappings and Sessions

Troubleshooting bottlenecks in existing Data transformation mappings

Contact this candidate