PROFESSIONAL SUMMARY

• 9.6 years of strong IT experience in end to end implementation of Data warehouse/BI systems in requirement gathering, Data Analysis, Dimensional modeling and ETL design.
• Expertise work experience on ETL tools Informatica Powercenter and Pervasive Data Integrator to build the data warehouse.
• Expertise in ETL architect and Data warehouse design methodologies to achieve the complex data processing into Data mart & warehouse.
• Well experienced in translating the requirements into the technical specifications for ETL development.
• Strong work experience on Relational Databases such as Oracle, SQL server 2008, UDB2.
• Strong in UNIX Shell script & DOS bat scripting to automate the jobs in a scheduler.
• Expertise in Performance tuning of ETL objects and SQLs.
• Basic knowledge about Hadoop framework including Pig and Hive.
• Strong leadership skills in managing the Project deliverables and team management.

TECHNICAL SKILLS

ETL Tools: Informatica Power center, Pervasive Data Integrator

Databases: Oracle, SQL Server, UDB2

Scheduler: Autosys, Control - M, Windows Task Scheduler

Languages: C,C++,Java

Defect Tracking: HP Quality Center, Service Now

Operating System: Windows, Unix

PROFESSIONAL EXPERIENCE

Sr. Consultant

Confidential

Responsibilities:

• Understand the Discover Banking business process to implement the Data mart and DWH.
• Coordinate with business team to understand the business.
• Prepare the ETL technical specifications as per the requirement.
• Determine & Design the database staging area for the ETL development.
• Provide the ETL design methods, tuned solutions and reusable objects for an efficient design.
• Developed SCD maps to keep track of the historical data.
• Developed complex ETLs for the fact table loads by using various transformations.
• Tuned the ETL maps and sessions by applying tuned techniques and session portioning.
• Developed Materialized views for the data aggregation to speed up the reporting performance.
• Code review and deployment process across the environments.
• UNIX script to run the ETL jobs and job schedule in a scheduler.
• Coordinate with offshore development team on the project deliverables.
• Work with UAT team on the use cases and project testing.
• Accountable for the Project deliverables.
• Leading a team of 8 resources (onsite - Offshore coordinate model).
• Follow the Organization quality standards to deliver the flawless projects.

Environment: Informatica Powercenter 8.x, SQL Server, mainframe, Autosys.

Consultant

Confidential

Responsibilities:

• Understanding of the Confidential business process to implement the DWH.
• Coordination with onshore team to get the requirement understanding and translating them into Design for the development.
• Providing the ETL Design methods for each requirement for the development team.
• Developing the ETL mappings for the data transformation from Mainframe to SQL Server.
• Accountable for the project deliverables from offshore.
• Working with PA & UAT teams for the issues and fixes.
• Involved in code review and complex design implementation.
• Responsible to do the code setup across all the environments and scheduling the jobs in a scheduler.
• Keep track of project deliverables and resource utilization.
• Highlight the project risk and issues to the higher management well in advance for theSmooth implementation.
• Mentoring a team of 6 members.
• Follow the Organization quality processes for the project implementation.

Environment: Informatica Powercenter 8.x, SQL Server, mainframe, Autosys.

Developer Analyst

Confidential

Responsibilities:

• Implemented Informatica design Standards and best practices throughout the project to ensure consistency and Quality of the code.
• Determining the staging area to built the warehouse.
• Interacting with Source system experts and business users to understand the requirements and model the OLAP architecture accordingly.
• Define estimation model for the ETL deliverables and code management.
• Simplified the development of ETLs by creating mapplets, re-usable transformations to
• Developed Complex ETL’s and approval of the code for the higher life cycles.
• Identified performance bottlenecks to help optimize the existing ETL jobs at the mapping level, session level and database level to effectively reduce the total load time.
• Support QA and UAT as per schedule for the quick resolutions.
• Audit process, ETL code management, code review and smooth deployment.
• UNIX shall script for various data loads and Scheduling of the ETL jobs in the scheduler Control-M.
• Offshore, Onshore development coordination activities and work distributions among the team members.
• Trained the team members on the OLTP process to make an efficient quality of ETL code with zero bugs.
• Mentor to the team members.
• Responsible to follow the Hewitt Quality process for the quality.
• Managing the Team of 5 Associates.

Environment: Informatica 8.0, Cognos 7.1, DB2 Z/oS, Java, Mainframe, HPQC, Unix, Control-M.

Sr. SE

Confidential

Responsibilities:

• Attend the client trainings in Chicago for understanding the client business.
• Communicate with Onshore Analyst for understanding the business during my onsite journey.
• Prepare the ETL technical design documents as per business needs.
• ETL mappings have been developed for loading the dimensions and facts.
• Devloped the ETLs by using various transformations to extract the data from OLTP to staging and then to warehouse.
• Coded SCD- Type 1, Type 2, Type 3 mappings to keep track of historical data.
• Taken Informatica Admin responsibility for managing the users, Access of folders and security.
• Communicate with Reporting team to make necessary changes in the ETL to meet the business needs.
• Identified many Bottleneck issues and worked for the perfect solution.
• Supported QA team to understand the business requirements and providing issue resolution.
• UAT support and various data loading based on client needs.
• Responsibility to prepare Unit Test Plans and test executions of ETL code.
• Prod environment set up including ETL, DDL, Unix and Control-M scheduling.
• Offshore, Onshore development coordination activities.

Environment: Informatica 7.1.1, Cognos 7.1, UDB2, Unix, HPQC, Control-Windows NT.

Sr. ETL Developer

Confidential

Responsibilities:

• Responsibility to understand the design documents before developing the ETL code.
• Developed various ETLs to populate the warehouse database.
• Perform the Unit testing on developed code for minimizing the QA issues and data quality.
• Responsible to sync up QA environment with Dev for QA testing.
• Worked with QA people to provide the issue resolution.
• Responsible to create the Unit test plan and executions by using HP Quality Centre.
• Responsibility to create a Unix script for each workflow to run the job.
• Troubleshooting the mappings after the User Acceptance Testing.
• Responsible to refresh the data as per reporting and client needs across environments.
• Responsible for migration of Informatica mappings and workflows /sessions from DEV to QA, QA to QC and QC to PROD.
• Responsibility to take a lead on PROD migration to set up PROD environment..
• Responsibility to schedule ETL jobs in the Control-M to run daily, weekly and monthly.
• Offshore, Onshore development coordination activities.
• Sharing work balance from other team members and assisting them technically.
• Responsible for collaborate with DBA and Data Architects on implementation of database changes or migrations of DDL’s.

Environment: Informatica 7.1.3, Cognos 7.1, DB2, Oracle 9i, UNIX, Windows NT.

ETL Developer

Confidential

Responsibilities:

• Moniter the ETL load as per scheduler as a primary task.
• Data loading in various data marts and warehouse as per on demand request.
• Resolve the prod issues in a time line and rerun the ETL jobs.
• Closely work with various teams like DBA,BITECH and UNIXTech on the issue resolution.
• Responsibility to follow up with scheduler team (Control-M scheduling team) to schedule the ETL jobs to run.
• Prod load status should be updated to the onsite coordinator if any delays due to environment down.
• Tracking the data refresh status every day and updating the support documents.
• Holiday/weekend support activity in an absence of any team members.
• Attending the informatica trainings and self study for the development project.

Environment: Informatica 7.1.1, UDB2, UNIX, Control-M.