SUMMARY:

• Ten years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical and Financial Sectors.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Worklets and Workflows for data loads.
• Experience in resolving on - going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Experience in working with command line program pmcmd to interact with the server to start and stop sessions and batches, recover the sessions.
• Strong skills in SQL, PL/SQL functions, stored procedures to implement business logic in oracle database.
• Experience with relational databases such as Oracle 12c/11g/10g, SQL SERVER 2013/2008.
• Expertise in using SQL*LOADER to load Data from external files to Oracle Database.
• Versatile Team player with ability to adapt to various environments and ability to communicate at all levels of software development life cycle.
• Good communication and presentation skills, self-starter, quick learner, team player and a strong commitment towards Customer Satisfaction.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Informatica Teradata Developer

Responsibilities:

• Requirement analysis, data profiling, creating the source to target mapping document and defining the transformation logic using multiple database objects and complex systems. Design and Develop Informatica mappings, workflows to collect data from multiple data sources based on mapping specifications and load into Teradata database.
• Create Tables, Views, stored procedures, other database objects on Teradata, write SQL scripts. Create and execute the test cases as per the requirements. Analyze and tune long running SQL using Teradata query performance tuning techniques like collecting statistics, identifying the data skew, remediate spool space issues. Developed, schedule and perform impact analysis using ActiveBatch job scheduling tool. Use the organizations automated devops tool to propagate the code to higher environments, creating branch, build and deploy the components through CICD Jenkins, udeploy. Implemented Technical capabilities custom framework around the ETL process which enables Audit Balance and Controls, Business rule validations, Exception and exclusion management, security in data management and data provisioning

Confidential

Informatica ETL Developer

Responsibilities:

• Working on Informatica 10.2/9.6.1 and Oracle 12c to implement Data vault methodology in building Enterprise Data Warehouse. Parsed high - level design specification to simple ETL coding and mapping standards. Co-ordination with Business users to understand Business Requirement. Created mapping documents to outline data flow from sources to targets. Involved in preparing
• Technical Design document and Source to target mapping document. Conducted sessions with delivery team to understand business requirements and functional document. Handled PHDP and QNXT Conversion projects. Prepared ETL Strategy document and Unit test plan. Upgraded Informatica version from 9.6 to 10.2 Involved in Unit Testing, Peer reviewing with Development Team. Prepared migration document to move the mappings from development to testing and then to production repositories

Environment: Informatica Power Center 10.2/9.6, Unix, Oracle 12c, SQL Server, Tidal, Jira, HPQC

Confidential

Software Engineer

Responsibilities:

• Designed and developed mappings to load Target pharmacy data into CVS core table. Analyzed the source data, made decisions on appropriate extraction, transformation, and loading strategies Used Informatica debugging techniques to debug the mappings and session log files and bad files to trace errors occurred while loading.
• Worked with Control - M scheduling tool for jobs scheduling. Involved in Unit testing, User Acceptance testing to validate the data as per user requirements. Created and Developed re-usable transformations, mappings and Mapplets confirming to the business rules. Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results.

Environment: Informatica Power Center 9.5/9.1, Toad, Control-M, Unix, SQL Assistant, Oracle 11/g, SQL Server

Confidential

ETL Developer

Responsibilities:

• Developed mappings/Reusable Objects/Transformation/Mapplet by using mapping designer, transformation developer and Mapplet designer in Informatica Power Center 9.5/9.1. Involved in Design and development of new data warehouse (Analytical Data Warehouse) for better reporting and analysis. Worked with several vendors in sending outbound extracts and load in bound files into the warehouse. Worked on developing Informatica Mappings, Mapplet, Sessions, Worklets and Workflows for data loads. Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence
• Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations. Analyzed the source data, made decisions on appropriate extraction, transformation, and loading strategies Analyzed complex ETL requirements/tasks and provided estimates/ETCs. Worked with Code Data Mapping Application (CDMA) for file/table layouts, column names, source to target mappings, transformation logic and codes/code mappings. Executed sessions by defining the parameter values through ABC (Audit Balance Control) to track and re - run the failed session easily. Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading. Used RTC for migration to Qual and Prod, EQM testing, Business Validation, PDR review and approval. Worked with Tidal scheduling tool for jobs scheduling. Involved in Unit testing,
• User Acceptance testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements. Created and Developed re-usable transformations, mappings and Mapplets confirming to the business rules. Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results.

Environment: Informatica Power Center 9.5/9.1, CDMA, ABC, Facets, Toad, Tidal,Unix, Queryman, SQL Assistant, SAS, Oracle, MVS, oracle 11/g, SQL Server, Windows NT/2000.

Confidential

SQL/Informatica Developer

Responsibilities:

• Worked on dimensional modeling to design and develop STAR schemas by identifying the facts and dimensions. Designed logical models (relationship, cardinality, attributes, and candidate keys) as per business requirements using Erwin. Involved in designing the process flow for extracting the data across various source systems.
• Extensively used Informatica Power Center and created mappings using transformations like Source Qualifier, Router, Lookup, Update Strategy, and Sequence Generator etc. Worked on Teradata SQL Assistant to analyze the existing data and implemented new business rules to handle various source data anomalies. Extensively used Teradata utilities like Fast load, Multi load to load data into target database. Developed sessions using different types of partitions like round robin, hash key portioning for better performance. Involved in Developing UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts. Developed FTP scripts to send the data extracts to various downstream applications using OBIEE and Informatica. Automated UNIX shell scripts to verify the count of records added everyday due to incremental data load for few of the base tables in order to check for the consistency. Performed Unit Testing and verified the data and performed Error Handling on sessions in Workflow, which was extracted from different source systems according to the user requirements. Created scripts for Batch test and set the required options for overnight, automated execution of test scripts Involved in testing applications for the Business Continuation Plan. Conceptualized and developed initial and incremental data loads in Informatica using Update strategy transformation, variables. Responsible for regression testing ETL jobs before test to production migration. Provided support in handling file validation errors and database down and connectivity errors for daily and weekly batch loads. Investigated and fixed problems encountered in the production environment on a day to day basis.

Environment: Informatica Power Center 8.6, Oracle 10g, MS SQL Server, XML Files, TOAD, SQL, PL/SQL, Windows XP, UNIX.