SUMMARY

• 10 Years of experience in Data warehouse and Data Integration Technology. A multi - skilled IT analyst with in-depth knowledge of ETL.
• Have Strong experience in Data Warehouse Application development and support projects.
• 9 Years of experience as Informatica Power Center Developer and IDQ Developer.
• Strong experience in the Implementation of Extraction, Transformation & Loading (ETL) Life Cycle using Informatica Power Center.
• Good working knowledge in Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling. Has an extensive experience in entire lifecycle Knowledge of data warehousing development and complete SDLC life cycle project and Agile methodology and plan the releases through the scrum meetings.
• Working as a solution architect to design the ETL solution.
• 10 Years of experience in Data warehouse and Data Integration Technology.
• 9 Years of experience as Informatica Power Center Developer and IDQ.
• Completed Certification - “INFORMATICA CERTIFIED DEVELOPER”.
• Have strong knowledge in Informatica IDQ.
• Good knowledge in informtica MDM.
• Have Strong experience in Data Warehouse Application development and support projects.
• Always adhere to the agreed process and have good understanding of interaction management, incident management, problem management and change management to ensure that the required levels and quality of service are achieved within the resources agreed.
• Deep knowledge in DWH ETL framework.
• Extensively worked on Oracle SQL, UNIX standard command & shell scripting programming.
• Have strong ability to understand business requirements from client and translate them into technical
• Involved in Requirement gathering of the business/functional specifications and actively
• Participated in Technical design for the application.
• Have good knowledge in data testing and data validation, reconciliation process and fine-tuning ETL code
• Excellent analytical, problem solving skills and a motivated team player with excellent communication and inter-personal skills.
• Worked on compliance and governance programs and provide technical leadership for Dodd-Frank regulations at leading energy companies.
• Extensively Implementeddata reconciliation, Testing, Debugging skillsandPerformance tuningof targets, sources, transformation logics.
• Expertise in doing theRCA (Root Cause Analysis)and resolvingperformance bottlenecksand enhance for optimization of themappings, sessions and workflows.
• Expertise in Developing Mappings, Define Workflows &Tasks, Monitoring Sessions, Export & Import Mappings and Workflows.
• Good knowledge in Salesforce data integration, workbench, Org62 and wave analytics, JSON .
• Good knowledge in MongoDB NoSQL database, working with JSON.

TECHNICAL SKILLS

ETL Tool: Informatica PoweCenter, IBM InfoSphere DataStage.

Data Quality tool: IDQ

MDM tool: Informatica MDM 10.2

BigData: MongoDB NoSQL,JSON

BI Tool: Business Object, TIBCO Spotfire, Tableau

Ticketing & Change management Tool: IBM Rational Clear Quest, SM9(HP Service Manager), BMC Remedy

Quality Testing Tool: HP Quality Center

DBMS Tool: Toad for Oracle, PL/SQL developer, DB2, SQL Server2008, Teradata

Data Modeler Tool: CA ERwin Data ModelerOpen Source SoftwareTool: WinScp, Notepad++ etc.

Open source terminal emulator for UNIX: Putty

Scheduling Tool: Control-M, Cisco Tidal

Compliance monitoring tool: Autonomy Supervisor, Autonomy Investigator, Control Center.

Salesforce: Workbench, Org62, Wave Analytics

PROFESSIONAL EXPERIENCE

Confidential

Sr. Associate

Responsibilities:

• Working as a solution architect to design the ETL solution.
• Gathering requirements from the Business and preparing the high-level documents to ensure the requirements for MDM and Data Integration.
• Responsible for all kind of ETL Design, development using Informatica PC and IDQ.
• Working with MongoDB to read data and normalized as per MDM Member domain.
• Creating landing tables Staging Tables, Base Tables as per the data model and data sources.
• Developing mappings using various Data Quality rules, standardized and used Address doctor functions to feed data for MDM Hub.
• Responsiblefor design Informatica mapping /session/workflow to implement business rules and build the entire ETL Integration.
• Prepare test plans and test data for assigned work, perform unit testing.
• Responsible for preparing mapping documents and Update Technical design document based on requirement.

Confidential

Responsibilities:

• Requirement analysis for new ETL development
• Developing new data set for WAVE using Informatica.
• Responsible for all kind of ETL codedevelopment & Writing SQL as per Mapping Document.
• Responsible forAnalysis and resolution of technical errors that may potential impacts data and ETL performance.
• Responsiblefor design Informatica mapping /session/workflow to implement business rules and build the entire ETL Integration.
• Propose solution, work on Production issues, Bug fixing and Enhancement of ETL code.
• Prepare test plans and test data for assigned work, perform unit testing.
• Support UAT testing, data validation for business users and deliver business requirement on time.
• Responsible for preparing mapping documents and Update Technical design document based on requirement.

Confidential

Technical Lead

Responsibilities:

• Working as an Analyst in Dodd-Frank Compliance Regulatory Program for Shell Trading.
• Worked to Understanding position limit data for Dodd-Frank and other compliance reporting requirements
• Responsible for requirement analysis for new ETL development(Exchange Position Limit/MTM/LTR/ End of Day Valuation)
• Given solution for new ETL challenges and scope identifying for different source system (e.g. Endur Gas, Endur Oil, Power)
• Understanding the function spec for NUCLEUS, Blueprint, Endur Oil and Gas.
• Worked on Commodity Trading and Risk Management systems like Endur data validation, Nucleus etc.
• Identifying ETL challenges for implementation of the business requirement.
• Support
• Sr. ETL Developer for Dodd frank Repository.
• Designing of ETL integration for the developed code using Informatica.
• Validation of data and unit testing and creation of reconciliation report for handling reject records.
• Working as a Support analyst for Compliance and Regulatory team.
• Sending Daily valuation report to ICE eConfirm.

Confidential

ETL Informatica developer and Team Lead

Responsibilities:

• Requirement analysis for new ETL development.
• Extensively use ErWin data modeler tool for understand relational data modeling.
• Understanding the Data model and Data mart design and prepare Technical Design for ETL.
• Creation of Data marts.CDC data capturing and loading in DWH.
• Working as Offshore Team lead and ETL Developer.
• Involved in understanding business requirement and translate Technical design document.
• Developing ETL code and data testing and architecture design for ETL batch.
• Areas Involved in Code review and data validation and fine tuning.
• Actively involved in migrations activities.
• Create test cases and do the data validation. Worked on HPQC for bug identifying and test case uploading.
• Managing the team efforts for best results which would keep the client satisfied in every respect.
• Adherence to strict time lines which was required to complete the project in a short duration of time.

Confidential

ETL developer

Responsibilities:

• Worked as a ETL Developer.
• Requirement analysis for new ETL development.
• Involved in Job design in using ETL tool Data stage.
• Code review for new developed job according to the project standard.
• Data validation and Unit testing.

Confidential

Technical Associate

Responsibilities:

• Daily monitoring informatics jobs infa 7.1 and Infa 8.6Analyzing errors for failure jobs and fixing those issues.
• Finding root cause for those failures. Preparing daily Issue dashboard for client. To verify data load for 21 Sites. If data is not available then loading data for this missing site.
• Involving in migration activities from Informatica 7.1 to Informatica 8.6 Execution of non-scheduled jobs which need to be executed manually.
• Responsible for month end activities. Also, responsible for changes /enhancement in the production environment as per the requirement of client.
• Responsible for closing ticket raised by user through BMC Remedy
• Working in process improvement and automated of existing system.

Confidential

Responsibilities:

• Requirement analysis for new ETL development.
• Understanding the Data model and Data mart design for creation of Technical Design for ETL.
• Developing ETL code (Mapping, session & workflow) and data testing and architecture design for ETL batch.
• Involved in data validation and involved in Performance Tuning of mappings in Informatica.

Confidential

Responsibilities:

• Daily monitoring if all jobs are running successfully for a 6- billing system.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using ETL Framework.
• Created the environment for Staging area, loading the Staging area with data from multiple sources.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Fixing the issue, in case the job is aborted due to some reason.
• Verify if the data loads properly in the STG and ODS tables.
• In case the data is not loaded properly, manually running those ETL jobs.
• Reconciliation of data for 6 billing system with File Master.
• Execution of non-scheduled jobs which need to be executed manually on a daily basis.

Confidential

Responsibilities:

• Gathered business requirements from Business Analyst.
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.
• Designed and developed Informatica ETL mappings to extract master and transactional data from heterogeneous data feeds and load
• Developing jobs in Informatica and Unit testing.
• Loading data, data validation in BODI and Informatica
• Creating reconciliation report for data validation.
• Responsible for managing the transformations involved in the project and Migration activities.