SUMMARY

• Over 7 years of experience as experience in building Enterprise Data Warehouse, Data Marts, Operational data stores in various domains like Confidential, Insurance, Finance, and Retail using Informatica Power centre and developer.
• Experience with Informatica Power Centre 10.4.0, 9.x, 8.x IDQ 9.6.1, 10.1.1 MDM and Confidential, SQL server, Confidential databases.
• Expertise in using Confidential database and utilities like TPT, FASTLOAD, MULTILOAD, and BTEQ scripts.
• Experience in Analysis and collecting statics on Confidential tables and Columns to improve performance Database.
• Experience in developing Complex SQL queries and PL/SQL Procedures.
• Experienced in debugging and Performance tuning of the Informatica mappings, sessions, and workflows.
• Performed Unit testing /SIT testing and prepared testing documents as required by the client.
• Experienced in designing/understanding of the existing/new LDM/PDM (Logical/ Physical data model) and STM (Source to Target Mapping) documents.
• Basic Knowledge in Informatica MDM, Informatica Data Quality, Informatica Cloud, and Informatica DT Studio implementation.
• Acquired experience with all the aspects of SDLC (Software Development Life Cycle) like Planning, Analysis Design, Deployment, Testing, Integration and Support.
• Experience in working with slowly changing dimensions and change data capture.
• Developed Complex database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL.
• Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing, and Documentation.
• Experience in Agile methodologies. Good experience in Programming language/ Structural query language (PL/SQL).
• Experience in Creating and Updating Clustered and Non - Clustered Indexes to keep up the SQL Server Performance.
• Provided 24*7 on-call support while working on production environments and provided L3 and L2 technical support.

TECHNICAL SKILLS:

Rdbms: MS SQL Server, Confidential and Confidential

Language: Confidential - SQL, SQL,PL\SQL

Tools: SQL Server Management Studio (SSMS), Visual Studio, Toad, Jenkins, Udeploy.

ETL Tools: Informatica Power Center 10.4.0/10.1.1/9.6.1/9.5.1/8.6.1/7.1.1 and Informatica BDE 9.6.1

Confidential BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Crystal Reports 10.0 & Excel Power Pivot, Power BI, Tableau

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Informatica ETL Developer

Responsibilities:

• Used Informatica Power Center to extract/transform and load data from different operational data sources like Confidential, Flat files like CSV files, XML files, Cobol files, SQL server from which customers data is coming and is loaded into Confidential warehouse.
• Implemented Type 2 Slowly Changing Dimension (SCD) to access the full history of accounts and transaction information.
• Implemented Change Data Capture (CDC) using the MD5 function.
• Worked on Informatica command line utilities like PMCMD, PMREP.
• Responsible for the performance tuning of the ETL process Confidential source, target, mapping, and session levels.
• Responsible for troubleshooting bottleneck problems by creating the indexes Confidential database level.
• Created and configured workflows, worklets, and sessions using Informatica Workflow Manager.
• Made use of session log files and workflow log files to debug errors in mappings and sessions.
• Used Mapping Parameters and Variables for reusability of code snippets.
• Worked with version control tools like SVN and scheduler tools like autosys.
• Worked with Confidential utilities like Multiload, FastExport, and BTEQ scripts.
• Coded shell scrips in UNIX and used UNIX tools like WinSCP.
• Supported the testing team, UAT team and production support teams.
• Worked on complex mappings using transformations like Aggregator, Expression, Joiner, Filter, Sequence Generator, Connected and Unconnected Lookup, Dynamic Lookup, Filter, Router, Union, and Update Strategy using Informatica Power Center Designer

Environment: Informatica Power Center (PWC) 10.1.1, Confidential 16.20, Confidential Utilities, Toad for DB2, SQL Server Management Studio, Confidential 11g/12c, Confidential SQL Developer, Flat Files, .CSV, Jira, Confidential Confluence, Autosys, Putty, WinSCP, Notepad++

Confidential, Lafayette, LA

Informatica Developer

Responsibilities:

• Pharmacy Benefit Management (PBM) is a migration project. Optum is the existing process that used to validate the Eligibility, Coverage, Claims, and Clinical Formulary of the member.
• After Cigna collaborated with Health Spring which already has ESI process should validate instead of Optum.
• Involved in Business meetings to understand the business requirement specifications and implemented the ETL jobs using Informatica.
• Involved in developing the source to target process and mapping documentation.
• Participated in the review and approval of the technical transformation requirements document used to design and build the ETL modules in Informatica Designer.
• Designed and developed several complex mappings using various transformations like Source Qualifier, Aggregator, Router, Joiner, Union, Expression, Lookup, Filter, Update Strategy, Stored Procedure, etc.
• Prepared a best practice document to use when designing jobs to gain optimum performance by using appropriate partitioning techniques.
• Created/Enhanced Confidential Stored Procedures to generate automated testing SQLs.
• Created Understanding documentation and Release testing documentation on the tickets handled, and documented the issues found in a central repository.
• Involved in the code reviews prepared by the teams.
• Written Unit test cases and integration test cases for the developed code.
• Code migrations from one environment (DEV-QA-UAT-PROD) to another environment like (DDL’s, views, stored procedures).
• Documented the Unit and System Integration test results as per the team standards.
• Developed and implemented strategies for slowly changing dimensions, surrogate key generation and for incremental data loading.
• Performed performance tuning of jobs to improve the extraction, transformation and loading time of data.
• Created RM tickets for the deployment of active batch jobs, creating folders in DEV, QA, UAT and PROD
• Created CM tickets for the production deployments.
• Created Active Batch Job Plans and jobs for all the development and scheduling the jobs in active batch tool.
• Created production Runbooks, production Catalog etc.
• Production support for the warranty period timeline of 30 days.

Environment: Informatica Power Center (PWC) 10.4.0/10.1.1, Confidential 16.20, Toad for DB2, SQL Server Management Studio, Confidential 11g/12c, Confidential SQL Developer, Flat Files, .CSV, Confidential Team Foundation Server, Confidential Confluence, Rally, Active Batch V12 Console, Putty, WinSCP, Notepad++, GitHub, Jenkins, IBM Udeploy.

Confidential, Cincinnati, OH

Senior ETL Informatica Developer

Responsibilities:

• Involved in Data Modeling using different techniques.
• Interacts with business users to understand the requirements.
• Created technical specification documents, STM documents, detailed ETL designs, Unit test plans, Deployment plans, Turn over documents etc.
• Implemented Type 2 Dimensions (SCD Type 2) to maintain history in the Dimensions.
• Involved in requirement specification meetings to add/change requirement as per the changing ETL Scenarios.
• Worked with NoSQL database MongoDB and worked with it to perform many different operations
• Involved in ETL architecture meetings and any new tool implementations.
• Used complex Informatica mappings to extract data from the source system to the Staging DB.
• Converted complex Confidential PL/SQL Packages to Informatica Mapping/Mapplets.
• Converted complex Transformation requirements to Informatica Transformations to transform the Source data to match the target data.
• Involved in change control meetings every week.
• Created test plans and scenarios for development unit testing and data validation.
• Performance tuned slow running mappings by using best practices like Partitioning, SQL Overrides, etc.
• Generated fixed and variable length flat files and read XML files.
• Worked on the Confidential stored procedures and functions to confirm the data and have load it on the table.
• Worked on FTP commands for file transfer.
• Worked on tools like SQL developer, TOAD and DB Visualizer to write complex SQL queries.
• Developing data links and data loading scripts, including data transformations, reconciliations and accuracies
• Have a participated in all phases of Software Development Lifecycle (SDLC)
• Have advanced knowledge of Confidential -SQL and/or ANSI SQL, ETL and Data Warehousing
• Designing BI solutions with Confidential SQL Server
• Building state-of-art reports that deliver information in a user-friendly and efficient way
• Querying Confidential SQL Server
• Looking for root causes in case of solution failures

Environment: Informatica Power Center (PWC) 10.1.0/9.6.1, Confidential 11g, PL/SQL Developer, Confidential -SQL, Flat Files, MS Excel 2010, MS SQL SERVER 2008, UNIX, WinSCP, MS Access, Jira.

Confidential, Carmel, IN

Senior Informatica Developer

Responsibilities:

• Used various informatica transformations in the development of complex mappings.
• Extracted data from different heterogeneous source systems applied business logic using transformations and loaded to the target systems using Informatica power center.
• Document designs and architect data maps, develop data quality components and establish and/or conduct unit tests
• Create/maintain design related artifacts i.e. data models, Mapping documents, architecture diagrams, data flow diagrams
• Managing SharePoint 2010, SSIS 2008 and SSAS 2008 production, test and development servers
• Evaluating data file submissions and developing/maintaining SSIS packages for ETL processes
• New development as scoped and requested by the business
• Design reference data and data quality rules using IDQ and involved in cleaning the data using IDQ.
• Used IDQ to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes
• Analyzed and thoroughly studied various data sources and different development environments within the organization.
• Extensively worked on extracting the data from various flat files (fixed width, delimited), applying the business logic and then loading them to the Confidential databases.
• Extensively worked with Source qualifier, Filter, Joiner, Expression, Lookups, Aggregator, Router, Sequence Generator, and Update Strategy.
• Worked closely with business for requirement gathering and to understand the project needs.
• Interacted with environmental team and data architects in design and implementation data models.
• Designed and developed complex mappings to load the Historical, Weekly and Daily files to Confidential database.
• Extensively worked on data conversion and data cleansing.
• Created different move-it jobs to have inbound/outbound transition of files between WellCare and different vendors.
• Build SQL, Confidential -SQL queries implementing functions, packages, views, triggers, and tables
• written UNIX shell scripts created command task, and email task for providing the pre-session post-session requirements for various informatica jobs.
• Provide database coding to support business applications using Confidential -SQL
• Worked on automation of informatica job flow using autosys boxes/jobs.
• Extensively worked on basic SQL queries such as creating altering Tables, Indexes, Views also worked with PL/SQL stored procedures. Queried various tables to get resultant datasets as per the business requirements.
• Prepared ETL mapping documents explaining complete mapping logic.
• Prepared unit test document and performed unit testing, regression testing.
• Provided QA/UAT support while code promotion and worked with QA's to resolve any defects if found.
• Worked with the Release Management Team, the DBA Team, and the UNIX team for smooth code productions.

Environment: Informatica PowerCenter 9.6.1/9.5, Informatica Data Quality (IDQ), Confidential -SQL, Confidential 11g, PLSQL Developer, Flat Files, MS Excel 2010, MS Visual Studio 2010, UNIX, WinSCP, MS Access, Autosys.

Confidential

Informatica Developer

Responsibilities:

• Performed requirements gathering, developed Analysis & Design document (A&D), developed Project time line.
• Designed and developed the ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation.
• Developed standard mappings using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter for weekly, quarterly process to loading heterogeneous data into the data warehouse. Source files include delimited flat files, and SQL server tables.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy, Union, SQL, Java and Sequence generator.
• Executed sessions, both sequential and concurrent, for efficient execution of mappings and used other tasks like event wait, event raise, email and command.
• Used Informatica for loading the historical data from various tables for different departments.
• Developed Informatica mappings for Slowly Changing Dimensions Type 1 and 2.
• Created Mapplets for implementing the incremental logic, in identifying the fiscal quarter of the transaction and in calculating various requirements of business processes.
• Involved in the Unit & Integration testing of the mappings and workflows developed for the enhancements in the application.
• Code migration of Informatica jobs from Development to Test to Production. Performed Unit testing, Integration Testing, Job & Environment Parameters Testing along the way.
• Scheduled and ran Extraction and Load processes and monitored tasks and workflows.
• Tuned the MMW databases (stage, target) for better, faster and efficient loading and user query performance,
• Created Informatica mappings with PL/SQL stored procedures/functions to incorporate critical business functionality to load data,
• Extensively worked on performance tuning of mappings, sessions, Target, Source and various ETL processes.

Environment: Informatica 9.0.1, Confidential, DB2, NOSQL, Erwin, Confidential, SQL server, Shell scripting, TOAD.

Confidential

ETL Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment.
• Involved in Analysis of the current system and Design solutions to create a centralized data warehouse as well as planning migration solutions from the current system to the new system.
• Used Informatica to extract data from different Source systems DB2 and Flat files then into Confidential Target system.
• Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Actively involved in the scripting team for shell script to automate and migrate data from ODS to Data warehouse.
• Involved in different team review meetings.
• Involved in Development and Data Integration of the main components using Informatica Power Center.
• Used different Transformations like Expression, Router, Filter, Sequence Generator, Stored Procedure, Connected and Un-connected Look ups etc.
• Created the mapping and Functional Specifications.
• Managed software releases after each stage of the testing and defect removal. As well as resolving issues from UAT and System testing.

Environment: Informatica Power Center 8.6, Confidential 9i, UNIX Flat files, SQL, PL/SQL and UC4 Scheduling tool.

Confidential

Informatica Developer

Responsibilities:

• Performed requirements gathering, developed Analysis & Design document (A&D), developed Project timeline.
• Designed and developed the ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation.
• Developed standard mappings using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter for weekly, quarterly process to loading heterogeneous data into the data warehouse. Source files include delimited flat files, and SQL server tables.
• Extensively used Transformations like Router, Aggregator, Joiner, Expression, Lookup, Update strategy, Union, and Sequence generator.
• Executed sessions, both sequential and concurrent, for efficient execution of mappings and used other tasks like event wait, event raise, email and command.
• Used Informatica for loading the historical data from various tables for different departments.
• Developed Informatica mappings for Slowly Changing Dimensions Type 1 and 2.
• Involved in the Unit & Integration testing of the mappings and workflows developed for the enhancements in the application.
• Code migration of Informatica jobs from Development to Test to Production. Performed Unit testing, Integration Testing, Job & Environment Parameters Testing along the way.
• Scheduled and ran Extraction and Load processes and monitored tasks and workflows.
• Tuned the databases (stage, target) for better, faster and efficient loading and user query performance,
• Created Informatica mappings with PL/SQL stored procedures/functions to incorporate critical business functionality to load data,
• Extensively worked on performance tuning of mappings, sessions, Target, Source and various ETL processes.

Environment: Informatica 8.6, Confidential, SQL server, Shell scripting, Unix.