Sr. ETL Developer Resume Profile , USA

Reference Id: 82967     Posted on Thursday 17th September 2015      ETL Developer



Please note that this is a not a Job Board - We are an I.T Staffing Company and we provide candidates on a Contract and Full-time basis. If you need I.T.Professionals to fill a Contract or a Full-time Position, please call (800) 693-8939

Sr. ETL Developer Resume Profile , USA


 

TECHNICAL SKILLS

 

Technology Experience

Informatica 6.1/7.1/8.1/8.6/9.1/9.5, Ab Initio 1.14 (GDE) 2.14.1 Co-Operating system, Teradata V2R5, Oracle 9i/10g, MS SQL Server, Control-M, Autosys, Erwin, Business Objects (BOXI-R3.1), Oracle Warehouse Builder (OWB)

 

Tools

Informatica 6.1/7.1/8.1/8.6/9.1/9.5, Ab Initio Control-M, Erwin, Rational ClearCase, Mercury Test Director, BO, Remedy, Cognos

 

Domain Experience

Sales and Marketing, Services, Manufacturing, Card Payment, Finance, Healthcare, Customer experience, Human Resources, Transportation

 

RDBMS

Oracle 9i/10g/11gR2, SQL, PL/SQL, Microsoft SQL Server, Teradata V2R5, DB2

 

Experience

 

Confidential, Washington D.C                                                                             

Sr. ETL Developer

Developed the ETL program to extract the data from various source systems and load it into Enterprise data ware house for multiple projects in Amtrak which Includes Multiride , E-Ticketing, Labor , Meal check/Meal Period and State Partner to generate the revenue reports.

·     Analyzed and document business requirements.

·     Created high level design, technical design documents and mapping documents based on business requirements.

·     Contributed to logical and physical data modeling for the new enterprise data warehouse (EDW)

·     Configured, designed and developed of ETL and Enterprise Data Warehouse applications.

·     Optimized the complex ETL process using Performance Tuning Methods.

·     Done root cause analysis and fixed the critical (Sev 1/2) Production issue logged in Remedy within given SLA.

·     Monitored and executed the production jobs whenever required.

·     Performed unit, system and integration testing to validate source and target data and performed Internal Quality Auditing of the ETL code before delivery.

·     Created Informatica tasks and workflows to execute ETL processes.

·     Written complex SQL Query as per business requirement to fetch the data from relational tables

·     Done optimization on complex SQL query to improve the performance.

·     Created Slowly Changing Dimension (SCD) type1, type2, Slowly Growing Targets, and Simple Pass Through Informatica mappings to meet business requirement.

·     Developed Unix shell scripts to run the workflows and SFTP source/target files from various systems and Informatica process Automation.

·     Documented and designed technical architectures, ETL best practice and solutions as per business requirement.

·     Performed Informatica administration tasks including user creation, connections, folders, migrations (9.1 to 9.5), installation, upgrades and troubleshooting.

·     Done deployment of Informatica code using export/import and deployment group methods and govern standards and best practices

·     Setup and configure Informatica domains, services (repository, Integration).

·     Daily communication with SME/Business Analysts  via mail, chat, teleconferences.

 

 

Confidential                                                                                                                                                      

Senior ETL Developer/Lead                                                                                                                             

Developed ETL procedures to convert the Human Resources database (HRDB) from DB2/mainframe to Oracle/Unix platform and to facilitate integration with Health and Human Services HRDB.

·     Requirements Analysis - Identify sources of data and document business rules

·     Convert existing processing of HRDB data in to Informatica mappings and move all HRDB tables into  Landing/Staging area.

·     Perform one-time data migration to move all existing HRDB data to Enterprise data ware house (EDW)

·     Perform data validation and eliminate reliance on DB2/mainframe as a source.

·     Created complex SQL queries ,joins as per business requirement to fetch the data from Oracle Tables

·     Build Informatica ETL processes to load data through the Staging layer in to EDW

·     Support down-stream users and migrate the down-stream users from DB2 to Oracle

·     Created various Transformations like Lookup, Joiner, Aggregate, Expression, Filter, Router, and Update Strategy to implement the business logic.

·     Creating Informatica tasks/Workflows to perform the ETL execution.

·     Developed Ab Initio graph as per business requirement

·     Used various Ab Initio components like Lookup, Join, Reformat, Filter by expression, Rollup, Scan etc.

·     Performing unit/integrated testing of ETL process as per business requirements.

·      Involved in designing of star schema and snowflake schema for EDW.

·     Developed Unix shell script as per business needs.

 

Confidential

ETL Lead, MAS BI

Managed an ETL Development project for the Mid Atlantic State (MAS) region that transformed member data from various source systems and loaded the data to a target system from which operational and analytical reports were sent to Kaiser’s senior executive for business analysis.

·     Gathered requirements with business analyst in group sessions with on-site and offshore management.

·     Created high level design, technical design documents and mapping documents based on business requirements.

·     Created Ab Initio graphs to capture the Mid Atlantic State (MAS) region member data from various source systems and loaded the data to a target system .

·     Used various Ab Initio components like Lookup, Join, Reformat, Filter by expression, Rollup, Scan, Redefine format, Merge, Gather, Replicate, Sort etc.

·     Performed unit testing for Ab Initio graphs that were updated based on change requests and business requirements

·     Optimized complex ETL processes using Performance Tuning Methods.

·     Involved in unit testing, integrated testing and regression testing.

·     Created Informatica data validation mapping to validate the source system data based on business need.

·     Developed Complex Informatica mappings/workflows to perform ETL process from source to target systems.

·     Created and executed reports using BOXI R3.

·     Developed Unix shell scripts to schedule and execute ETL jobs using Crontab.

·     Worked on Informatica MDM, B2B and IDQ.

·     Worked with XML source and target as per business requirement.

·     Developed complex SQL to fetch the Source/Target data for analysis, testing and reporting.

·     Performed Informatica administration tasks including user creation, connections, folders, migrations (8.6 to 9.1), installation, upgrades and troubleshooting.

·     Setup and configure Informatica domains, services (repository, Integration).

·     Managed resources and identified and selected new project personnel.

·     Planned, managed and executed the project.

·     Managed and assigned tasks to a 7-member team.

 

Confidential

ETL Lead/Architect

Developed ETL procedures for an organization that delivers subscriber-centered, provider supportive services that optimize expenditures and improve health care for Medicare agencies, state and local governments, health plans, employers, and labor trust groups.

·     Reviewed and contributed to business requirement documents with business analysts and with on-site and offshore management teams.

·     Created detailed ETL design documents and mapping documents based on business requirements documents

·     Created various transformations using Lookup, Joiner, Aggregate, Expression, Filter, Router, and Update Strategy.

·     Estimated costs and monitored the quality of products and services.

·     Managed a team and assigned and supervised work from functional and technical perspectives.

 

Confidential

ETL Lead developer/Architect, Clearing and Settlement                                                                                

Implemented the logic and developed the architecture for the Visa Clearing & Settlement (C&S) application

·     Developed the Informatica mappings and workflows for C&S based on the business requirements document.

·     Contributed to logical and physical design of the C&S architecture.

·     Coordinated with business analyst to discuss the logic and ensure that the business requirements were implemented.

ETL Lead, Visa Distributing Processing Services                                                                                            

·     Designed ETL procedures for VDPS, the application that authorizes credit card payment transactions.

·     Created Ab Initio graphs based on business requirement documents using various components like Lookup, Join, Reformat, Filter by Expression, Rollup and Scan.

·     Coordinated with business analysts during requirements gathering for downstream data feed management system and to develop code for enhancement requests.

·     Developed code to extract data from journal files coming from the VDPS switch.

·     Performed unit testing for Ab Initio graphs that were updated based on change requests and business requirements.

·     Fix bugs and defects identified during system integration and regression testing.

·     Provided second level production support for resolving high severity (severity 1) issues.

 

Confidential

Senior ETL Developer

Developed ETL procedures to migrate data from an existing data warehouse to an integrated enterprise level data warehouse.

·     Created and executed mapping using Slowly Changing Dimensions Type 2, Slowly Growing Target, and Simple Pass Through.

·     Prepared technical designs for Informatica mappings.

·     Developed mapping for fact loading from various dimension tables.

·     Contributed to logical and physical data modeling for the new data warehouse.

·     Created BTEQ, MLOAD and FLOAD scripts for loading and processing input data.

·     Created and executed macros using Teradata SQL Query Assistant (Queryman).

 

Confidential

Senior ETL Developer, Center for Excellence                                                                                                  

Maintained Oracle Data marts for Dell Premier Customers and resolved issues that impacted the Finance, Service, Customer Experience, Manufacturing and Telecom domains.

·     Designed and developed mappings based on customer requirements specifications.

·     Conducted root cause analysis to fix issues and eliminate bugs that were identified by business users.

·     Contributed to Table Space Reorganization to maintain Oracle Data marts.

ETL Developer                                                                                                                                                  

Supported a system that measures issues that occur within 60 days of shipping that are caused by incomplete, incorrect, and damaged orders.

·     Developed Teradata macros to automate SQL procedures.

·     Created Ab Initio graphs to capture the cost impact of shipping and order fulfillment issues versus customer experience.

·     Used various components like Join, Filter by Expression, Rollup, Lookup, and Sort.

Confidential

ETL Developer

Designed a Data Warehouse using Informatica to improve business decision-making for a leading manufacturer of electronic equipment.

·     Coordinated with executives, senior managers, and business analysts to design ETL processes to consolidate information from file sources and an Oracle DB into a target Oracle data warehouse.

·     Created various transformations like Lookup, Joiner, Aggregate, Expression, Filter, Router, and Update Strategy.

Confidential

ETL Developer

Created a Data Warehouse to support a Sales Analysis System for one of the leading suppliers of specialty food products and consumable meat products.

·     Created, scheduled, and monitored workflows using Informatica Workflow Manager & Monitor to prevent process failure.

·     Developed and optimized mappings in Informatica Power Center to load data into the data warehouse using Slowly Changing Dimensions.

·     Supported unit testing and regression testing.

 

Search Resumes

Looking for I.T Professionals on a Contract basis?