SUMMARY

• 8+ years of IT experience in Software Development Life Cycle (SDLC) in Waterfall, Agile methodology (Sprint/Scrum) based projects which includes requirement gathering, designing, implementing and testing
• Experienced on Manufacturing, Health Care Domain and Financial Applications
• 8 years of Technical and Functional experience in Production Support - Data warehousing implementing ETL (Extract, Transform and Load) using Informatica PowerCenter 10.2/9.6/9.5/8.6
• Solid understanding of ETL design principles and good practical knowledge of performing ETL design processes through Informatica PowerCenter.
• Extensively worked on PowerCenter Mapping Designer, Mapplet Designer, Transformation developer Warehouse Designer, Workflow Manager, Repository Manager and Workflow Monitor
• Well acquainted with Performance Tuning of sources, targets, mapping and sessions to overcome the bottlenecks in mappings.
• Good understanding of Star and Snowflake Schema, Dimensional Modeling, Relational Data Modeling and Slowly Changing Dimensions.
• Good analytical and conceptual skills in database design and implementation of RDBMS concepts.
• Experienced in Teradata Macros & Oracle database development using PL/SQL, Stored Procedures, Triggers, Functions and Packages.
• Experience in UNIX shell scripting (file validations, file downloads, workflow executions).
• Migration from Datastage 11.5 jobs to Informatica PowerCenter 10.2
• Excellent communication and interpersonal skills.
• Exceptional problem solving and sound decision-making capabilities, recognized by associates for quality of data, alternative solutions, and confident, accurate, decision making.

TECHNICAL SKILLS

Informatica Tools: Informatica PowerCenter 10.2/9.6/9.5/8.6, Datastage 11.5

Database: Teradata 16, Oracle 12c, MS SQL Server 2016 and DB2

Languages: SQL, PL/SQL

Scripting: Unix shell scripting

BI Tool: Tableau

Operating Systems: Windows Environment and UNIX

Version Control: Accurev, GitHub

Scheduling Tools: Autosys 11.3, Control-M 8.0

PROFESSIONAL EXPERIENCE

Confidential, CA

ETL Consultant

Responsibilities:

• Working on multiple projects using Informatica as ETL tool to extract data from multiple source systems (Flat files, DB2 and Oracle). Participated in gathering, analyzing, and documenting business requirements, functional requirements and data specifications.
• Involved in creating the design and technical specifications for the ETL process based on Functional specifications.
• Extracted data from various sources like Oracle, flat files,DB2.
• Developed mappings using Informatica Power Center Designer to transform and load the data from source systems to target database.
• Used various transformations like Source Qualifier, Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure and Lookup to develop robust mappings in the Informatica Designer.
• Facilitate knowledge transition to new members joining the team. Maintain Knowledge Repository with current training materials and project specific documents.
• Implemented Slowly Changing Dimension Type 1 for applying INSERT else UPDATE to Target tables.
• Involved in Version Control of Repository Objects using Check-in and Check-out.
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Extensively worked on Workflow Manager and Workflow Monitor to create, schedule and monitor Workflows.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters for the delta process to extract only the additional data added during that period.
• Worked with mappings to dynamically generate parameter files used by other mappings.
• Update Strategy, Joiner, Stored Procedure and Lookup to develop robust mappings in the Informatica Designer.
• Extensively worked on Workflow Manager and Workflow Monitor to create, schedule and monitor Workflows.
• Worked with mappings to dynamically generate parameter files used by other mappings.
• Informatica Scheduler was used to schedule jobs on daily and hourly basis.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged the mapping of the failed session.

Environment: Informatica Power Center 9.5.1/8.6.1 (Power Center Designer, workflow manager, workflow monitor),Oracle 11g, TOAD, Windows XP, Reporting Services.

Confidential, CA

ETL Developer

Responsibilities:

• Requirements gathering and requirements analysis through coordination with business analysts and define business and functional specifications.
• Provided documentation of ETL design and technical specifications, high level and low-level design specifications.
• UsedInformaticaPower Center 9.6 for extraction, transformation and load (ETL) of data into the data warehouse.
• Worked extensively on different types of transformations like Source qualifier, Expression, Filter, Aggregator, Lookup, Sequence generator, Router and Joiner.
• Worked onInformaticaAdvanced concepts & also Implementation ofInformaticaPush Down Optimization and Partitioning.
• Created mapplets and reusable transformations to leverage the coding efforts and to help code maintenance.
• Used Type 2 SCD logic inInformaticato load Slowly Changing Dimension tables.
• Created complex stored procedures, functions, triggers, and tables and materialized views.
• Developed complex SQL code to read data from source system and in lookup transformations.
• Worked with testing team to define a robust test plan and support them during the functional testing of the application.
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Identifying & removing the bottlenecks, tuning the mappings and sessions to improve performance.
• Precise Documentation was done for all mappings and workflows.
• Review and deploy the code.
• Prepare and use test data/cases to verify accuracy and completeness of ETL process.

Environment: InformaticaPower Center 9.6, Oracle, UNIX, Autosys.

Confidential

ETL/Informatica Developer

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on Business rules.
• Used Informatica power center 8.6.1 to migrate the data from OLTP to data warehouse.
• Used Informatica Power Center 8.6 for extraction, loading and transformation (ETL) of data in the DataMart.
• Used Informatica workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Implemented “Slowly changing dimension type 2” to represent historical data correctly.
• Designed and developed ETL Mappings to extract data from flat files, MS Excel and Oracle to load the data into the target database.
• Developing several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica Power Center.
• Extensively used ETL processes to load data from various source systems such as DB2, SQL Server and Flat Files, XML files into target system applying business logic on transformation mapping for inserting and updating records when loaded.
• Responsible for design and developing Teradata BTEQ scripts, MLOAD based on the given business rules and design documents.
• Experience in migration Informatica objects from 8.6 to 9.x.
• Experience in Informatica upgrade testing, troubleshoot and resolve issues.
• Created complex mappings in the designer and monitored them. The mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator transformations.
• Ran the workflows on a daily and weekly basis using Active Batch Scheduling tool.
• Examined the workflow log files and assigning the ticket to the Informatica support based on the error.
• Experience in developing Unix Shell Scripts for automation of ETL process.
• Performed operational support and maintenance of ETL bug fixes and defects.
• Maintained the target database in the production and testing environments.
• Supported migration of ETL code from development to QA and QA to production environments.
• Migration of code between the Environments and maintaining the code backups.
• Designed and developed Unix Shell Scripts, FTP, sending files to source directory & managing session files.
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Developed PL/SQL code at the database level for the new objects.

Environment: Informatica Power Center 8.6, Oracle 10g/9i, PL/SQL, Flat files, XML, MS Access, SQL Server 2008.

Confidential, PA

Informatica Developer/ Production Support

Responsibilities:

• Involved with Business Analysts in requirement gathering and worked on converting Business needs into Technical Requirements in the form of DataMapping documents,businessrules documents and Function Design and Functional Specification Document.
• Created Technical specifications documents based on the Functional Design document for the ETL code to build theDataMart.
• Performed Impact Analysis on Database objects using Toad for Oracle.
• Involved in Informal Sessions with the Data modeling team to develop an Architectural Solution Created PL/SQL Functions, Stored Procedures, Packages, Cursors and Triggers.
• Created Informatica mappings/workflows from scratch to load the files to the Downstream using Transformations in Informatica PowerCenter.
• Experience in writing complex joins, Correlated Subqueries and using Analytical functions like Rank, Dense Rank, Row number using Toad for Oracle.
• Involved in designing Metadata Tables and Journal tables.
• Wrote complex SQL queries and worked on Query Optimization techniques.
• Experience in Data warehousing concepts like OLAP, OLTP, Slowly Changing Dimension (SCD) types (I, II &III) methodologies, Incremental Loads and Change Data Capture (CDC).
• Wrote my own set of test cases to perform Unit Testing, involved in requirement walk through to the Testers and provided QA support.
• Worked closely with the Release Management team and maintained Requirement Traceability Matrix document using MS Excel.
• Coordinated with the onsite team and offshore teams.