Informatica ETL Developer

Location:

Coppell, TX

Salary:

100k

Posted:

July 18, 2018

Contact this candidate

Resume:

Adil Yousuf

ETL Informatica Developer

**************@*****.***

405-***-****

Summary

Total 7+ years of IT experience in Analysis, Design, Development, Implementation, Testing and support of Data Warehousing and Data Integration Solutions using Informatica PowerCenter 9.6.1/9.5.1/8.6, Oracle.

Experience in ETL (Extraction, Transformation and Loading) of data from various sources into EDW, ODS and Data marts using Data Integration Tool Informatica, 9.x/8.x, Oracle in Banking, Insurance, Retail, Telecom and Health care Domains.

Monitoring and Developing solutions of exiting Batch jobsin Control-M.

Updation of Calanders and User daily according to Scheduling requirements.

Experienced in Data warehouse development, working with data migration,Data conversion and Extraction/Transformation/Load using Informatica PowerCenter.

Experience in Performance Tuning of Database queries, Running on Voluminous Data.

Tuning Informatica Mappings for performance by finding bottlenecks and enhancing performance.

Worked on Relational and Dimensional Data Modeling.

Understanding of ETL design process and principle, development and maintenance and Repository configuration using Mapping Designer, Repository manager, Sessions, Worklets, Workflow Manager/Monitor and Server tools – Informatica Server, Repository Server manager.

Involved working on the transformations like Source Qualifier, Filter, Joiner, Aggregator, Expression and Lookup.

Using standard practices in Data warehousing : Star Schema/Snowflake Schema, Fact and Dimensions tables and Slowly changing Dimensions(SCD1,SCD2,3).

Solid understanding of OLAP (Online Analytical Processing) concepts.

Worked in Software Development Life Cycle (SDLC) like Agile and Waterfall methodologies.

Experience in the Implementation of full lifecycle in Enterprise Data warehouse, Operational Data Store (ODS) and Business Data Marts with Dimensional modeling techniques.

Analysed the backend capabilities and Implemented Push down optimization for Performance gain in Informatica.

Extensively worked in creating Unix shell scripts and automation of ETL project, Monitoring and Scheduling of Jobs using UNIX Shell Script.

Experience in documenting High Level Design (HLD), Low level Design (LLD), STM's, Unit test plan, Unit test cases and Deployment documents.

Hands on experience in the reconciliation process and checking integrity (IC ) of Datawarehouse.

Worked on Databases like Oracle, SQL Server, Netezza and Worked on integrating data from Flat files like fixed width /delimited, XML files.

Supported on Unit testing, Functional testing and User Acceptance testing on UNIX and Windows Environment and worked on Solving the incidents/Defects and Providing hotfixes, writing and debugging to find out the problems in mappings, troubleshooting and rectifying ETL bugs.

Participated and understood business requirements, discussed with Business Analyst to gather and analyze the requirements and to prepare business rules.

Collaborated with Decision Management system team for creation of business rules to be deployed on IBM ODM

Worked with PMCMD to interact with Informatica Server from command line and execution using Unix scripts for quick automation.

Proficient at using Excel for Data Analysis and using Advanced excel functionalities like Pivot,Vlookup and More.

Analysis of PL/Sql Procedures and implementing the functionality in Informatica.

Education

Bachelors of Science in Industrial Safety

Masters of Business Adminstration (MBA) Project Management

Skills

Data Warehouse Tools : Informatica PowerCenter

Operating Systems: Windows XP/Vista/Windows 10/08/07, Unix, Linux,Redhat

Databases : Oracle 11g/10g/9i, MySql, SQL Server, Netezza

Dimensional: Data Modeling Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling

Database Tools: Oracle SQL Developer, SQL Plus, Toad, Aginity Workbench, MySql Xampp

Languages: SQL,Unix Shell Scripting, PL/SQL, XML

Experience

Toyota Motor Corporation July-2017 Present

Data Integration Programmer

Production Support and providing the solutions to the errors in ETL jobs. ETL Process consist of Building dynamic parameter files, Landing, ODS layer and then Integration layer in such a way that identified the Data Model with respect to subject areas.

Analyzing Sales data and creating Informatica mappings for generation of Hourly, Daily, Weekly, Monthly and Yearly Reports.

Worked on establishing ETL Design in such a way that each ETL Jobs identified to data model (subject area).

Responsible to build System design, ETL data flow diagram, Building of Data Mapping Sheet and Run Book.

Monitor loads and troubleshoot any issues that arise.

Build Dynamic parameters ETL Process in Importing the data from flat files

Build Address transformation to validate the address.

Processing financial data for timely profit calculation.

Decision support system to be used for Sales and marketing.

Build in depth test Cases and automate the test cases by writing the Integrity checks.

Worked on data profiling and automate the process of test cases

Data mapping sheets for subject areas like Revenue generation, Sales, Cost centre analysis, Finance, Prior Authorization for new dealers.

Building Views for validating data mapping sheets

Building views in the integration layer.

Building validation queries for data validation of source system (Oracle 11g) and Created Validation mappings.

Writing Functions/procedures for data validation

Writing shell scripts for pre and post command sessions

Setting up reconciliation ETL design for staging and Integration layer

Setting up Event ID and Batch ID for the ETL process.

Environment: Informatica Power Center 9.6.1, Control M, Oracle 11g, ALM, XML/XSD,Flat file Sources, UNIX, SharePoint

PNC Bank, Pittsburgh, PA Jan 2016 – Jul 2017

ETL/Informatica Developer

PNC Financial services group, Inc.PNC is an American financial corporation.PNC operations include a regional banking franchise operating primarily in nineteen states and the District of Columbia with more than 2,600 branches. This project is developed for maintaining a catalogue of all the products that are offered online to the customers. It involved extraction of data from multiple Source systems and loading them through an ETL process in to staging tables and then in to Target tables.

Interact with business analysts, Analyzed, inspected and translate business requirements into technical specifications.

Participated in system analysis and data modeling, which included creating tables, views, triggers, functions, indexes, functions, procedures, cursors.

Involved Creating Fact and Dimension tables using Star schema.

Extensively involved working on the transformations like Source Qualifier, Filter, Joiner, Aggregator, Expression and Lookup.

Created session logs, workflow logs and debugger to debug the session and analyze the problem associated with the mappings and generic scripts.

Design and developed complex Informatica mappings including SCD Type 2 (Slow Changing Dimension Type 2).

Extensively worked in Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows.

Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.

Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.

Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.

Environment: Informatica PowerCenter v 9.6, Oracle 11g, Flat files (fixed width/delimited, XML, SharePoint, JIRA, Quality Center.

State Farm Insurance, Chicago, IL. Feb 2015 – Jan 2016

ETL/Informatica Developer:

State Farm Insurance is one of the leading companies in the nation for the auto insurance with more than 10 million policyholders. Its companies have consistently received high ratings for financial strength and claims paying ability from various independent rating agencies. The Insurance DW project was developed in an effort to streamline the entire process of Insurance and to keep track of various financials on a daily, weekly, monthly basis. Claims, Premium, Loss and Contracts were some of the modules to deal with.

Responsibilities:

Worked with Business Analysts and DBA for requirements gathering,business analysis and designing of the datawarehouse.

Extensively worked on the transformations like Source Qualifier, Filter,Router, Joiner, Aggregator, Expression and Lookup.

Worked on Informatica PowerCenter tool - Source Analyzer, Target Designer, Mapping Designer, Mapplets Designer and Transformation Developer.

Created Mapplets and used them in different Mappings.

Created Workflows and Sessions to load data from the SQL Server, Oracle, flat file, and XML file sources that exist on servers located at various locations.

Created and monitored workflows and task using Informatica PowerCenter Workflow Manager.

Responsible for creating business solutions for Incremental and full loads.

Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.

Created high-level design document for extracting data from complex relational database tables, data conversions, transformation and loading into specific formats.

Created schema objects like indexes,views and sequences.

Developed standard and re-usable mappings and Mapplets using various transformations like Expression, Lookups, Joiner, Filter, Source Qualifier, Sorter, Update strategy and Sequence generator.

Environment: Informatica PowerCenter 9.5.1, Oracle 11g,fixed width/delimited f, Erwin, Putlat files,XML Source,Putty, WinScp, Linux, XML, Sharepoint, Quality Center.

United Healthcare,Minneapolis,MN Aug 2013 – Feb 2015

ETL/Informatica Developer:

United HealthCare Group Is an innovative leader in Health and Well-being industry. United is dedicated to making business decisions that reflect its commitment to improving the health and well-being of its members, associates and the communities. During this project, worked closely with ETL team,customers,business analysts and other colleagues in the IT department to analyze operational data sources,determine data availability,define the data warehouse schema and develop ETL processes for the creation,maintenance,administration and overall support of the data warehouse.

Worked with Business Analysts for requirements gathering, implementing designs process, development and preparing business rules.

Worked in Software Development Life Cycle (SDLC) like in Agile Scrum methodologies.

Actively performed in the meeting and providing comments for user story review meeting in Agile Scrum environment.

Created Complex Mappings to load data using transformations like Source Qualifier, Expression, Aggregator, Dynamic Lookup, Connected and unconnected lookups, Joiner, Sorter, Filter, Stored Procedures, Sequence, Router and Update Strategy.

Created Mappings using parameters, used Session parameters, Mapping variable/parameters and created Parameter files and runs of workflows based on changing variable values.

Worked on complex mapping for the performance tuning to reduce the total ETL process time.

Developed ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, Flat Files and SQL server, and loaded into Oracle.

Developed Informatica Workflows and sessions connected with the mappings using Workflow Manager. Implemented Slowly Changing Dimensions (SCD Type 1 & 2) in Mappings.

Hands on experience using query tools like SQL Developer, PLSQL developer, Teradata SQL.

Involved in creating new table structures and modifying existing tables discussing with Data Modeler.

Experience in writing documentation like Micro documents from Macro documents, High level and low level design, analyzing Source to Target Mapping (STM’s), Test cases and Code migration report.

Developed Mapplets, Source and Target definitions, mappings, Reusable Transformations, using Informatica PowerCenter 9.6.1

Update the tables as per the requirements by generating queries using SQL to check the data consistency in the table.

Checked Sessions and error logs to troubleshoot problems and also used debugger.

Created Unix Shell Scripts to automate pre-session and post-session processes.

Created shortcuts for reusable transformation, source/target definitions, mapplets in Shared folder.

Environment: Informatica PowerCenter 9.1/9.5, Oracle 10g, Power mart, Pl/SQL, Flat files (fixed width/delimited),, Putty, WinScp, Linux, XML, Sharepoint, Quality Center.

AT&T,Ralegh,NC Mar 2012 – Aug 2013

Informatica Developer

Enterprise Data warehouse for AT&T. This data warehouse is developed to help the top executives make decisions about the products (Network Bandwidth) and to also analyze various metrics and understand the performance of the business. Data in EDW is consumed by different systems like Business Intelligence reporting using Business Object, Decision support Systems, Executive Information, Demand Planning, Automated Underwriting systems.

Interacted with business analysts and translate business requirements into technical specifications.

Participated in system analysis and data modeling, which included creating tables, views, triggers, functions, indexes, functions, procedures, cursors.

Using Informatica designer, developed mappings which populated the data into the target.

Extensively worked Creating Fact and Dimension tables using Star schema.

Created session logs, workflow logs and debugger to debug the session and analyze the problem associated with the mappings and generic scripts.

Designed and developed complex Informatica mappings including Slow Changing Dimension Type 1,2.

Extensively worked in Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows.

Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.

Environment: Informatica PowerCenter v 8.6/9.1, SQL server 08, Oracle 10g/9i, PL/SQL, SAP BO, SSRS, Windows NT, Flat files (fixed width/delimited), MS-Excel, UNIX shell scripting, Putty, WinScp.

JC Penny,Plano,TX Feb 2011 – Mar 2012

Informatica Developer:

This project was initiated to deliver customer-centered service across the ecommerce enterprise. While enhancing the online and mobile shopping experience, this project also aimed at creating better in Store solutions ranging from POS to Inventory to Datawarehouse management, involved in continuous Mobile application enhancement project for easy access and user friendly navigation to the site, focused on Retail management

Worked closely with project managers, business analysts, DBA’s to achieve business and functional requirements.

Extensively worked on the transformations like Source Qualifier, Filter, Joiner, Aggregator, Expression and Lookup.

Worked on Informatica PowerCenter tool - Source Analyzer, Target Designer, Mapping Designer, Mapplets Designer and Transformation Developer.

Assisted in the design and Maintenance of the Metadata environment.

Created Workflows and Sessions to load data from the SQL Server, Oracle, flat file, and XML file sources that exist on servers located at various locations.

Extensively used Source Qualifier Transformation to filter data at Source level

Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.