SUMMARY

• 7.5 years of experience and high performance in System Analysis, design, development and implementation of ETL, MDM and Relational Database Systems using Informatica Power Center, Informatica MDM, Oracle, SQL, PL/SQL, UNIX, Core Java, STIBO STEP and HIVE in Travel and Hospitality, Life Science, Telecommunication domains.
• Over 5 years of experience in requirement clarifications and requirement analysis.
• Over 4 years of experience as Informatica ETL developer.
• 1 year of experience as Informatica MDM developer.
• 1 year of experience in HIVE.
• 3 months of experience in Core Java.
• Have 3 years of Operation Support experience as Data Analyst Lead.
• Worked as ETL/Informatica Dev Lead, being responsible for development, maintenance and support of ETL jobs to read transform and load data from and to various systems.
• Strong experience in Data quality analysis, SQL debugging, QA activities (test case development, execution).
• Experience in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the ETL system.
• Proficient in developing strategies for ETL mechanism by giving solutions to clients and vendors like improving existing system, improving / tuning the performance of ETL jobs.
• Provided ETL Informatica Power Center expertise to mentor other developers following best practices and standards.
• Presently working as offshore lead and data analyst for Master Data Management support program where Informatica MDM and Informatica Power Center tools are being used.
• Certified in Big Data and Hadoop framework - Having concepts on HDFS, HIVE, Map reduce, PIG.

TECHNICAL SKILLS

ETL Tools Informatica Power Center: MDM Tools Informatica MDM Hub

Programming languages: SQL, PLSQL, UNIX

Back end tools: SQL developer, TOAD

PROFESSIONAL EXPERIENCE

Senior Developer

Confidential

Responsibilities:

• Analyzed and fixed defects in Supplier Chain hub.
• Analyzed the Business Requirements and involved design of enhancements.
• Working as Support Lead.
• Working with other vendors like STIBO, Data Pipe to support client in efficient way.
• Played leading role to follow ITIL process and help client to maintain ITIL process.
• Provided guidance to the new team members and to make them comfortable with the business and provide guidance for improvement.

Confidential

Responsibilities:

• Team leading, involved in ETL and MDM requirement clarifications.
• Analyzed the Business Requirements.
• Involved in Data Analysis.
• Provided guidance to the new team members and to make them comfortable with the business and provide guidance for improvement.
• Participated in analysis ETL and MDM business requirements.
• Provided help to develop ETL and MDM requirements

Confidential

Responsibilities:

• Analyzed the Business Requirements.
• Involved in ETL and MDM requirements.
• Involved in developing ETL mappings and MDM hub objects following the coding standards.
• Provided guidance to the new team members and to make them comfortable with the business and provide guidance for improvement.

Confidential

Responsibilities:

• Involved in developing ETL mappings and MDM hub objects following the coding standards.
• Involved in preparation of test cases for production migration and perform post - migration Data validation and data analysis in production environment to ensure successful migration is performed
• Provided direction to team members for finding out the root cause of the problem along with that validate and impact analysis of the resolution prepared by team members.
• Participated in understanding the requirement, provide guidance to implement the new requirements and also implement the requirements, designing the data extraction strategy, defining rules for data cleansing.
• Coordinating with the testing team and the UAT team before migrating any production fixes.
• Tuning the performance of SQL procedure and understand the requirements of Index and create whenever required.

Confidential

Responsibilities:

• Involved in source provided data analysis.
• Involved in data analysis.
• Involved in understanding the business requirement.
• Participated in designing the data extraction strategy using ETL approach.
• Involved in implementing the ETL and MDM objects.
• Provided guidance of preparation of test cases for production migration and perform post - migration Data validation and data analysis in production environment to ensure successful migration is performed.
• Participated in coordinating with the testing team and the UAT team before production deployment.