SUMMARY

• 5+ years of experience in Information Technology including Data Warehouse/Data Mart development using ETL/Informatica Power Center.
• Worked on various domains; Banking and Financial services, Insurance and Healthcare.
• Good exposure in overall SDLC life cycle.
• ExpertiseintheDataAnalysis, Design, Development, Testing, Production Support of Database/Datawarehousing applications for various industries.
• Experience in creating high level and low level design documents.
• Excellent understanding of Data warehousing Concepts - SCD Type1/Type2/Type3, CDC, Dimension & Fact tables, Schemas (Star and Snowflake), Normalization and De-normalization.
• Worked in various Heterogeneous Source Systems like Oracle, Netezza, MS SQL Server, Oracle Cloud API and Flat files.
• Vast experience in creating complex mappings, sessions, workflows, reusable components in Designer, Workflow Manager using various transformations like Source Qualifier, Expression, Unconnected and Connected Lookups, Router, Filter, Aggregator, Joiner, Update Strategy, Stored Procedure, Rank, Transaction Control, SQL etc.
• Extensively created mapplets, reusable transformations and look-ups for better usability.
• Experienced in SQL Queries (Analytic Functions, SQL joins, Nested Queries, Unions, Multi-table joins), PL/SQL procedures and packages.
• Good experience in identifying bottlenecks in various levels like Source data pull queries, mappings and sessions.
• Experienced in performance tuning both at database level and Informatica level. Tuned the SQL query using Indexes, Partitions etc. and Informatica code tuning using Informatica Partitioning, Push Down Optimization, Buffer size adjustments etc.
• Experienced in writing UNIX shell scripts/commands for pmcmd and file handling operations like file manipulation, file watch, file pattern search, file archive and purge.
• Experience in implementation of various Data Reconciliation methodologies.
• Experienced in scheduling jobs using Autosys and ESP. Have scheduled for various scenarios including various calendars and holidays.
• Experience working in both Agile and Waterfall model. Have undergone Agile classroom training and have actively involved in agile process like Planning, Stand up call & Retrospection etc. Have used Rally tool to update stories.
• Strong experience in performing Informatica objects migration from one environment to another environment. Development to TEST, UAT, PVS and Production using DevOps tools Jenkins, Git and Urban Code Deploy.
• Good experience in performing/supporting Unit testing, System Integration Testing (SIT), UAT testing of codes.
• Well experienced in coordinating different functional groups (DBAs, System Admins, Business teams, QA and Support teams).

TECHNICAL SKILLS

Tools: Informatica Power Center 10.1/9.6/9.5/9.1/8.6

Databases: Oracle 12c/11g/10g, Netezza, MS SQL Server, Hive

Languages: C++, SQL, PL/SQL, UNIX

Scheduler Tools: Autosys, ESP

Agile Tools: Rally

Versioning Tools: Perforce, Clearcase

Softwares: Toad for Oracle, Toad for Data Analyst, Putty

PROFESSIONAL EXPERIENCE

Confidential

Sr. Informatica Developer

Responsibilities:

• Interact with business to gather requirements and make analysis on existing source data.
• Build ETL for extracting the data from source systems, make improvements in data to create better quality of data.
• Creating views over data mart tables and provide as reports to client for analysis purposes.
• Created mapplets and worklets for reusability.
• Created complex ETL to fetch data from Oracle API into CLOB and then parse the JSON format data to readable format.
• Push down optimization, Informatica Partitioning, Database partitioning and Indexing are implemented to improve the performance.
• Implemented auto restart of workflows based on the volume of data read from API.
• Complex queries and logics built in Hadoop (Hive).
• Implemented data reconciliation. Scheduled run of workflows through ESP.
• Migration of codes done through Dev Ops process using Git, Urban Code Deploy.

Environment: Used: Informatica 10.1, Oracle 12c, SQL Server, Hive, UNIX, Toad for Oracle, ESP, Git, Urban Code Deploy

Confidential

Informatica Developer

Responsibilities:

• Lead a team of 4 members to do the ETL development.
• Involved directly with Business in Requirement gathering, participated in design process.
• Built stage layer and Data warehouse in Netezza and Data mart in Oracle.
• Developed numerous Informatica mappings involving complex logics to pull data from various source systems.
• Since most files handled were full file on a daily basis, CDC was done using SQL minus queries and loaded to targets.
• Developed shell scripts to handle file watcher, file transfer using (SFTP, NDM), trigger the process and sending email task based on file availability.
• Informatica Partitioning and Push down optimizations were implemented to improve the performance of the code.
• Created view over data mart layers for downstream usage.
• Scheduled all jobs through Autosys.
• Developed mapplets and reusable transformations to reduce the redundancy of transformation usage.
• Came up with Data validation and Reconciliation methodology which was greatly appreciated by clients.
• For the migration project, identified the list of codes to be moved from Informatica 8.6 to 9.1 and list of tables to be moved from SQL Server to Oracle. Developed codes and there were many compatibility issues because of difference in version and database which all has been resolved and successfully migrated.

Environment: Used: Informatica 8.6/9.1/9.6, Oracle 10g/11g, Netezza, MS SQL Server, Clearcase, Perforce, UNIX, Visio, Toad for Oracle, Toad for Data Analysts, Autosys.

Confidential

Informatica Developer

Responsibilities:

• Involved in gathering requirements from Client.
• Developed ETL codes to pull data from files and Oracle source systems which had different system data like Customers, Various policies, Renewals, Upgrades etc.
• Once all data was consolidated and brought to a Data mart system, PL/SQL procedures were created to create different reports like Future Estimated Revenue from Renewals, List of future Renewals, List of pending payments etc.
• Database partitioning and Indexes were implemented to tune the report performance.

Environment: Informatica 8.6, Oracle SQL & PL/SQL, UNIX, Autosys.