ETL Developer
Resume:
FELIX G. MOENGA
**************@*****.***
ETL DEVELOPER
●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.
Responsibilities:
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
CARDONE INDUSTRIES, ARLINGTON, TX.
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.
Responsibilities:
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
WINSUPPLY INC, DAYTON OH.
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.
Responsibilities:
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
TMG HEALTH, SCRANTON, PA.
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
INFORTRAK RESEARCH AND CONSULTING, Nairobi, Kenya
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
Responsibilities:
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