SUMMARY

• in data analysis, design and development of various business applications.
• Experience in implementing Data Warehousing applications using Informatica Power Center.
• Expertise in relational (MS - SQL Server, DB2, Oracle and Vertica) databases.
• Well verse with UNIX shell scripting.
• Complete hands on experience in all phases of SDLC.
• Experience in performance tuning of mappings, sessions, workflows.
• Worked on Slowly Changing Dimensions (SCD's), implemented Type1, Type 2 to keep track of historical data.
• Extensive experience in extraction, transformation and loading of data from heterogeneous source systems like flat files, excel, relational DB.
• Worked extensively on complex mappings.
• Strong Business knowledge in Compliance, Surveillance, Financial Domain and Investment Banking.
• Experienced in working on Migration project.
• Extensive knowledge and experience in AGILE (Scrum) Methodology.

TECHNICAL SKILLS

ETL Tool: Informatica Power Center 10.x, 9.x, 8.x (Designer, Workflow Manager, Workflow Monitor and Repository Manager)

Languages: SQL and UNIX Shell Scripting

Database: MS-SQL Server, IBM DB2, Oracle and Vertica

Other Tools: Autosys, JIRA, Bitbucket, Git Bash, WinSCP, Cutover, Perforce, Deployment tool, Migration tool, Service Now, SharePoint, Toad Data Point, NPR, Tidal 6.2, HP QC, Jenkins, Confluence, Putty, BrokerTrax, CognosUI

PROFESSIONAL EXPERIENCE

Confidential

Sr. Informatica ETL Developer

Responsibilities:

• Managed feed generation for almost 450+ clients on specific schedules.
• Worked very closely with Research, Sales team to gather client requirement.
• Used Informatica PowerCenter to interface with varied source systems as Oracle, SQL Server, Flat Files and load into Vertica tables.
• Created Informatica workflow using partitions and Vertica bulk writer for improved performance.
• Created VSQL scripts to load data from stage to various tables in Vertica Database.
• Handled ad-hoc client feed requests and monitored target files in Unix servers and sent for Business Review.
• Created Unix shell script to send email to teams for multiple clients on weekly, fortnightly and monthly basis.
• Created a script to dynamically generate the email body based on frequency.
• Used Autosys to orchestrate batch processing and created multiple Autosys Calendars for job run schedules.
• Utilized Bitbucket for versioning and code check-in using GitBash.
• Performed UAT in every sprint by sending Prod and QA feeds to Business for sign off.
• Performed annual ARC/DR Testing by validating Prod failover to DR server.
• Prepared Technical Specification document for all the (JIRA)User stories assigned.

Confidential

Sr. Informatica ETL Developer

Responsibilities:

• Worked closely with the BST team to plan and analyze data requirements and mapping documents.
• Created design documents listing the ETL process flow and flowcharts for each application code.
• Developed ETL \ Reconciliation tools using complex mapping transformations.
• Created Unit Test Cases to validate the code.
• Added jobs and created grouping for pre-migration and migration in Tidal job scheduler.
• Managed Non-Production Request System (NPR) for deploying code, scripts, and jobs from DUT to SIT/UAT.
• Performed Unit Testing, Integration Testing and User Acceptance Testing.
• Worked on various Conversion Pilot (CP) and Migration Rehearsals (MR) before the actual Go Live.
• Maintained Activity Tracker which records the progress of all the tracks during migration cycles.
• Performed Defect triage and reworked on migration tools ahead of upcoming MR.
• Participated in reporting Status and metrics to PMO on tasks, schedule and results.

Confidential

Sr. Informatica ETL Developer

Responsibilities:

• Created Informatica mappings with extensive use of aggregator, union, filter, router, normalizer, joiner, sequence generator, stored procedure and lookup transformation.
• Package the different components and deploy the solution to QA and UAT environments.
• Lead the discussions with upstream and BA team to streamline the Job scheduling and execution.
• Address production issues by performing root cause analysis, implementing and deploying the fix within SLA.
• Coordinated with production support team for production deployment. Created CR using Service Now.
• Performed post deployment health checks and monitored for any issues during the initial job execution.
• Performed peer review of new development and enhancement as per business requirement.

Confidential

Informatica ETL Developer

Responsibilities:

• Worked to consume large amount of data and process them in most efficient manner, considering dependency on other data load/feeds.
• Developed the system to consume data feeds received from front office, middle office and back office up-streams.
• Worked with BA to analyze the requirements and translate them into high level technical design.
• Assist QA/BA team for data testing.
• UNIX shell scripting to process files and archiving process.
• Unit test, integration test and deployment of code to upper environment.

Confidential

Informatica ETL Developer

Responsibilities:

• Contributed in data analysis and design, according to business requirement of client.
• Extensively worked in Data ETL process from source to target systems.
• Developed and implemented the UNIX shell script for various requirements.
• Performed unit testing at various levels of the ETL.