PROFESSIONAL SUMMARY:

• 7 years of Strong experience in Complete Software Development Life cycle (SDLC) which includes Business Requirements Gathering, System Analysis, and Design, Development, and Implementation of Data warehouse.
• Experience in Data Warehouse using Informatica Power Center v 10.2/9.6.1/ 9.5.1/9.1/8.6/8.5/8.1/ (Repository Manager, Mapping Designer, Workflow Manager, Workflow Monitor).
• Experience working with IICS Informatica intelligent cloud services to load data to and from between Salesforce, Snowflake and On - prem systems
• Complete understanding of regular matching, fuzzy logic and dedupe limitations on IDQ suite.
• Experience on PowerCenter mapping detailed transformation information in the catalog (EDC) setting-up Enterprise Data Catalog (EDC v 10.2x) tool on Linux platform Implement Data Governance in Informatica, EDC based on data validation performed in IDQ.
• Working knowledge of Informatica Power Exchange to support Change data capture.
• Strong experience in development in BI tool Informatica Power Center, Informatica cloud (IICS) and Informatica Power Exchange.
• Experience working with EDI standard files like 834, 835, 837, NCPDP and HL-7 Files using Informatica B2B DT and DX.
• Experience in using Oracle 11/10/9i/8i, MS SQL Server 2005/2012/2016, Azure SQL Data warehouse, Teradata v15, Snowflake, AWS Redshift, SQL, TSQL, and PL/SQL.
• Worked with Dimensional Data warehouses in Star and Snowflake Schemas, slowly changing dimensions and created slowly growing target mappings, Type1/2/3-dimension mappings.
• Proficient in transforming data from various sources (flat files, XML, Oracle) to Data warehouse using ETL tools.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations
• Extensively experience in developing Informatica Mappings / Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and Creating Workflows with Worklets& Tasks and Scheduling the Workflows.
• Extensively involved in Informatica performance issue and Database performance issue, Expertise in error handling, debugging and problem fixing in Informatica.
• Experience in design of logical and physical data modeling using E/R studio. Expertise in using SQL*LOADER to load Data from external files to Oracle Database.
• Extensive experience in writing PL/SQL programming units like Triggers, Procedures, Functions and packages in Unix and windows environment.
• Exposure to on-shore and off-shore support activities
• Excellent verbal and communication skills has clear understanding of business procedures and ability to work as an individual or as a part of a team.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.2/9.6.1/9.1/8.6/8.5/8.1, Informatica Power Exchange, IICS Informatica cloud, IDQ, Informatica developer.

Data Modeling: Erwin 7.2/7.0, Toad, Oracle Designer, PL/SQL Developer 5.1.4.

Databases: Teradata v15, Oracle 11g/10g/9i/8i, SQL Server 2005/2012/2016, Azure SQL data warehouse, Snowflake, Salesforce.

Programming: SQL, PL/SQL, T-SQL, SQL*Plus, HTML, Batch, UNIX Shell Scripting.

Environment: UNIX, Windows 2000/2003/XP/Vista, LINUX.

PROFESSIONAL EXPERIENCE:

Confidential ; Pittsburgh, PA

Sr. ETL Informatica Developer

Responsibilities:

• Developing code using Teradata Scripts, Informatica mappings, workflows, and sessions as per ETL specifications and implemented CDC (Change Data Capture) scripts wherever required.
• Involved in loading the data into Azure SQL DWH from on premise systems and flat files using complex Informatica mappings.
• Exporting the Mapplets from IDQ into Informatica Powercenter to use the mapplet in various mappings for implementation of Address doctor.
• Hands on experience working on profiling data using IDQ.
• Experience in Salesforce.com (SFDC), on demand CRM tool.
• Worked with Oracle, SQL Server, Azure SQL DWH, Salesforce, and Flat file sources.
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
• Identified performance issues in existing sources, targets, and mappings by analyzing the data flow, evaluating transformations, and tuned accordingly for better performance.
• Perform data extraction, transformation, and loading (ETL) between systems using Informatica Powercenter and Informatica Cloud (IICS).
• Loaded data to EDI system and clinical documentation.
• Create packages and stored procedures with error handling techniques
• Setup the batches, configured the sessions and scheduled the loads as per requirement using Control M scheduler.
• Expertise in Data Warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing and Documentation.
• Prepared the documentation for the mappings and workflows.
• Made use of post-Session success and post-Session failure commands in the Session task to execute scripts needed for cleanup and update purposes.
• Developed UNIX scripts for automation of Informatica jobs.
• Performing Test cases and various test scenarios to validate the ETL load
• Developed PL/SQL and Batch Scripts for scheduling the sessions in Informatica.
• Involved in Unit testing, Integration testing UAT by creating test cases, test plans and helping Informatica administrator in deployment of code across development, test, and prod repositories,
• Actively involved in the production support and transferred knowledge to the other team members.
• Co-ordinate between different teams across circle and organization to resolve release related issues.

Environment: Informatica Power Center 10.2/10.1 (Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), IDQ, Power Exchange), SQL Server 2012, SQL DWH, Snowflake, ADLS Gen 2, XML

Confidential ; Jersey City, NJ

Sr.ETL Informatica Developer

Responsibilities:

• Analyze functional and technical specification documents and design use cases documents.
• Create Sessions and Workflows to load data from the Different Source Systems into Database which in turn feeds the downstream applications using tool Informatica PowerCenter.
• Building ETL Informatica applications for receiving and processing data to build data warehouse/data mart environment for reporting and analytical purpose using tools like Informatica PowerCenter, SQL and Scripting.
• Extensively used Informatica Data Explorer (IDE) &Informatica Data Quality (IDQ) profiling capabilities to profile various sources, generate score cards, create and validate rules and provided data for business analysts for creating the rules.
• Write complex SQL override scripts at source qualifier level to avoid Informatica joiners and Lookups to improve the performance.
• Develop mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Aggregator, Update strategy and Sequence Generator.
• Modifying the existing ETL code and scripts as per the user requirements.
• Expertise in using Teradata Utilities BTEQ, M-Load, F-Load, TPT and F-Export in combination with Informatica for better Load into Teradata Warehouse.
• Responsible for Production Turnover for moving ETL Informatica objects (workflows/sessions, mappings), Database objects (functions, stored procedures, DDL queries), scripts from Test to QA to Prod.
• Provide backup support of databases, ETL applications environments.
• Participate in daily, weekly meetings to discuss data quality, performance issues and ways to improve data accuracy and new requirements, etc. Created test plans and did unit testing for the Informatica BDE mappings and stored procedures
• Actively involved in the production support and transferred knowledge to the other team members.
• Co-ordinate between different teams across circle and organization to resolve release related issues.

Environment: Informatica Power Center 9.6.1 (Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Informatica IDQ, Power Exchange, SQL Server 2008, T-SQL, Teradata, DB2 8.1, XML, Autosys, Oracle 11g, PL/SQL, UNIX.

Confidential ; West Des Moines, IA

ETL Informatica Developer

Responsibilities:

• Worked closely with client in understanding the Business requirements, data analysis and deliver the client expectation.
• Used InformaticaPowerCenter 9.6/8.6.1/8.5 and its all features extensively in migrating data from OLTP to Enterprise Data warehouse.
• Extensively used Erwin for Logical and Physical data modeling and designed Star Schemas.
• Extracted data from different sources like Oracle, flat files, XML, DB2 and SQL Server loaded into DWH.
• Created complex mappings in PowerCenter Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed mappings/Reusable Objects/mapplets by using mapping designer, transformation developer and Mapplet designer in InformaticaPowerCenter 9.6/8.6.1/8.5
• Worked on power exchange to create data maps, pull the data from mainframe, and transfer into staging area.
• Handle slowly changing dimensions (Type I, Type II) based on the business requirements.
• Automated the jobs thru scheduling using Maestro scheduler, which runs every day by maintaining the data validations.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary. Also re-wrote some queries as needed.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Migrated mappings, sessions, and workflows from development to testing and then to Production environments.
• Involved in Performance tuning for sources, targets, mappings, and sessions.
• Performed unit testing on the Informatica code by running it in the Debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for optimum performance.
• Wrote PL/SQL stored procedures & triggers, cursors for implementing business rules and transformations.
• Worked extensively with different caches such as Index cache, Data cache and Lookup cache (Static, Dynamic, Persistence and Shared).
• Created deployment groups, migrated the code into different environments. Worked closely with reporting team to generate various reports.

Environment: Informatica Power Center v 8.6.1/8.5 (Power Center Repository Manager, Workflow Manager, and Workflow Monitor), SQL Server 2005.

Confidential ; Chicago, IL.

ETL Informatica Developer.

Responsibilities:

• Analyze the business requirements and framing the Business Logic for the ETL Process and maintained the ETL process using Informatica Power Center.
• Work extensively on various transformations like Normalizer, Expression, Union, Joiner, Filter, Aggregator, Router, Update Strategy, Lookup, Stored Procedure and Sequence Generator.
• Develop an ETL Informatica mappings to load data into staging area. Extracted data from Mainframe files, flat files, SQL Server and loaded into Oracle 11g target database.
• Create workflows and work lets for Informatica Mappings.
• Write Stored Procedures and Functions to do Data Transformations and integrate them with Informatica programs and the existing applications.
• Work on SQL coding for overriding for generated SQL query in Informatica.
• Involve in Unit testing for the validity of the data from different data sources.
• Developed workflows for dimension loads, fact loads based on daily/monthly runs.
• Developed code to archive monthly data into history tables and effective use of the history table to load the data back into the system for a particular past month.
• Developed Audit tables to keep the track of ETL Metrics for each individual run.
• Experience working with Audit Balance control concept to create the parameter files dynamically for each workflow before its run.

Environment: Informatica Power Center v 8.5 (Power Center Repository Maager, and Workflow Monitor), SQL Server 2005.