SUMMARY

• Around 7 years of Data Warehousing ETL experience using Informatica Power Center 10.x/ 9.5/9.1/8.5/7.1.
• Good experience in Data warehousing, Business Intelligence and Informatica developing ETL solutions.
• Have clear understanding of Data warehousing concepts with emphasis on ETL and life cycle development including requirement analysis, design, development, and implementation.
• Very strong knowledge in Informatica PowerCenter suite which includes Mapping Designer, Workflow Manager, Workflow Monitor, Admin Console and Repository Manager.
• Extensive working experience in design and development of data warehouse, marts and ODS.
• Handful working experience in Data warehousing development with data migration, data conversion and extraction/transformation/loading using Informatica PowerCenter to extract & load data into relational databases like SQL Server, Oracle, DB2.
• Have good debugging skills and Extensive experience in maintenance and production support of Informatica.
• Extensive working experience with PowerCenter components of Informatica server and client tools like designer, workflow manager, repository manager and workflow monitor.
• Extensively worked with Informatica mapping variables, mapping parameters and parameter files.
• Excellent Hand full working experience in running projects by using scheduling tools like Informatica Scheduler, TWS.
• Strong knowledge and understanding of data modelling (Star and snowflake schemes), ER diagrams, Data flow diagrams/Process diagrams.
• Extensive knowledge in optimizing techniques such as concurrent caching, Auto memory calculations, partitioning and using push down optimization.
• Worked with Oracle, SQL stored procedures, table partitions, triggers, SQL queries, PL/SQL packages, IBM SQL procedural languages and loading data into data warehouse/data marts using Informatica, DB2 load and SQL loader.
• Developed shell scripts for invoking Informatica workflows and for running batch process.
• Extensive experience in designing the architecture for extract, transformation, load environment and development of mapping and process using Informatica PowerCenter.
• Extensive experience in formulating error handling mechanism.
• Excellent analytical skills in understanding client’s organizational structure.
• Good knowledge and experience in Agile and Waterfall methodologies.
• Excellent problem - solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills.
• Excellent team player with very good communication skills and leadership qualities.
• Experience with coordinating and leading onsite-offshore development.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.x/9.x

Database: Oracle 11/12/19, SQL Server 2014/2008/2005 , Netezza

Scheduling Tools: Control-M, TWS, Informatica Scheduler

Languages: SQL, T-SQL, PL/SQL, C, C++

Scripting Languages: UNIX Shell Scripting, Korn Shell, Bash shell scripting

Operating Systems: Windows, MSDOS, Linux, Unix, Redhat

PROFESSIONAL EXPERIENCE

Sr. Informatica Developer

Confidential, Plano, TX

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica PowerCenter 10.4, 0racle 19c, PL/SQL, UNIX, Control-M

Sr. Informatica Developer

Confidential, Dallas, TX

Responsibilities:

• Involved in design and developing the end-to-end ETL process.
• Experience in ETL processes utilizing informatica Power center tools to design data conversations from a variety of relational, XML and flat file source systems to data warehouse/data marts.
• Wrote and ran different types of SQL queries, including create/insert/update on given databases.
• Involved in weekly error tracking and correction process using Informatica.
• Created Complex ETL Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, Connected and unconnected lookups, Filter, Sequence, Router and Update Strategy.
• Involved in Data Modeling and design of Data Marts in Star Schema methodology with confirmed, granular dimensions and fact tables.
• Assisted Business Analyst with drafting the requirements, implementing design and development of various components of ETL for Various applications

Environment: Informatica PowerCenter 10.2, 0racle 11g, MS SQL Server 2014, PL/SQL, UNIX, Windows.

Sr. Informatica Developer

Confidential, Shamburg, IL

Responsibilities:

• Involved in business requirement analysis and prepared functional requirement document
• Involved in the ETL technical design discussions and prepared ETL high level technical design document
• Good proficiency in Informatica Power Center and Informatica Data Quality.
• Extensively used ETL to load data using Power Center from source systems like Flat Files into staging tables and load the data into the target database Oracle. Analyzed the existing systems and made a Feasibility Study.
• Involved in full software development lifecycle from the throughout the development and support finance industry using Informatica Power Center, Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
• Experience in ETL processes utilizing Informatica Power center tools to design data conversions from a variety of relational, XML and flat file source systems to data warehouse/data marts.
• Developed mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Update strategy and Sequence generator.
• Wrote and ran different type of SQL queries, including create/insert/update on given databases
• Involved in Unit, System integration, User Acceptance Testing of Mapping.
• Familiar with Agile software methodologies (scrum).
• Played a key role in designing the application and migrate the existing data from relational sources to corporate warehouse effectively by using Informatica Power center.
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Worked with Business users to fix defects and implemented the best practices for conducting unit testing and integration testing and documenting the test results for user acceptance.
• Supported the process steps under development, test and production environment.

Environment: Informatica PowerCenter 10.2, IDQ, 0racle 11g, MS SQL Server 2014, TERADATA 14.0, UNIX, Windows.

Informatica Developer

Confidential, Buffalo Grove, IL

Responsibilities:

• Collaborated with Businesspeople for requirements gathering and Participated in translating the business requirements into technical requirements.
• Involved in design and developing the end-to-end ETL process.
• Designed and developed complex mappings in Informatica to load the data from various sources such as SQL Server, Flat files and loading into Teradata.
• Extensively used different transformations such as Source qualifier, look up (connected and unconnected), Expression, Aggregator, Update strategy, Sequence generator, Joiner, Filter, Rank, Normalizer and Router transformations.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Extracted data from diverse sources like Oracle, SQL Server, COBOL files and Flat Files.
• Used version mapping to update the Slowly Changing Dimensions to keep full history to the target database.
• Created, configured, scheduled and monitored the sessions and workflows based on run on demand, run on time using Informatica Powercenter Workflow Manager and Workflow Monitor.
• Involved in weekly error tracking and correction process using Informatica.
• Worked with Pre-and-Post Session SQL commands to drop and recreate the indexes on data warehouse using Source Qualifier Transformation of Informatica Powercenter.
• Worked on Informatica Data Quality for Data Profiling, Data Cleansing, Data Validation.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Worked with complex queries in SQL for optimization.
• Formatted Reports as per the user requirements using extensive functionalities in SAP Business Objects, which allows the users to analyse the data.
• Perform the unit testing for files using UNIX commands.
• Perform the unit testing as per the design document and mapping design flow.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and databases.

Environment: Informatica Power Center 10.1, Informatica Data Quality 10.1, DB2, SQL Server, PL/SQL, Oracle 11g/10g, TFS, TWS

Informatica Developer

Confidential, Springfield, IL

Responsibilities:

• Interacted with business users and business analyst to understand reporting requirements and understanding the mapping documentation.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Used Informatica to develop objects for extracting, cleaning, transforming and loading data into data warehouse.
• Perform System Analysis and Requirement Analysis, design and write technical documents and test plans.
• Worked with Management for creating the requirements and estimates on the Project.
• Assisted Business Analyst with drafting the requirements, implementing design and development of various components of ETL for various applications.
• Planning and Requirement analysis for large scale Centralized Wealth Data Warehouse.
• Coordinated with DBA in creating and managing tables, indexes, table spaces and data quality checks.
• Created Complex ETL Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and unconnected lookups, Filters, Sequence, Router and Update Strategy.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Implemented Slowly Changing Dimensions both SCD Type 1 & SCD Type 2.
• Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing.
• Communicate with business users to understand their problem if required and send workaround to solve the issue and find the root cause and advice if required any enhancement.
• Responsible for tuning of ETL processes.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle.
• Developed various Informatica Workflows to load the data from various upstream systems using different methodologies i.e. trigger based pull, direct pull & file based push.
• Extracted data stored in a multi-level hierarchy using Oracle Stored Procedures.
• Published the records to downstream applications with help of ETL power center with the help of message queue.
• Design and develop mappings, sessions and workflow as per the requirement and standards.
• Created various AutoSys jobs for the scheduling of the underlying ETL flows.
• Created the ETL exception reports and validation reports after the data is loaded in the warehouse database.
• Used Informatica debugger in finding out bugs in existing mappings by analyzing data flow and evaluating transformations and done unit testing for the individual developed mappings.
• Responsible for making changes in the existing configuration wherever required, making customizations according to the business requirements, testing and successfully moving the changes into production.
• Modified existing mappings for enhancements of new business requirements.
• Translated the PL/SQL logic into Informatica mappings including Database packages, stored procedures and views.
• Worked on performance tuning of the mappings, ETL Environments, procedures, queries and processes.

Environment: Informatica 9.6.1, Oracle 11g, PL/SQL, MS-Excel, MS-Access.