SUMMARY:

• Around 9.5 Years of solid IT industry experience with 8.6 years of extensive experience as a LEAD in Informatica PowerCenter, Data Warehousing and Data integration projects.
• Informatica Certified Specialist Developer.
• Having in depth Informatica development knowledge and also worked in support.
• Strong Hands - on experience with ETL Testing and tools of Powercenter Informatica Designer, Workflow manager, Workflow Monitor and Repository Manager.
• Well versed with Data Warehousing concepts and ETL designs for loading Star Schemas/ Snowflake schemas.
• Sound knowledge in PowerCenter transformations and also Workflow manager, Repository manager, Workflow Monitor.
• Good understanding and hands on Performance tuning of mappings / sessions in Informatica PowerCenter.
• Strong hands-on in Oracle 9i, 10g, 11g and on PL/SQL, Functions, Procedures, Triggers and Cursors.
• Strong implementation knowledge in informatica mapplets, SQL overrides, load types, session partitioning.
• Sound knowledge in SQL query writing and Data engineering skills.
• Very good Debugging skills in issues pertaining to Oracle and Informatica PowerCenter.
• Experience in applying approaches such as profiling and perform the DQ checks for the data loads.
• Good experience in concepts of Data analysis and Data modelling for mid level issues.
• Extensively performed Unit Testing, System Testing, Integration testing, Functional testing and User Acceptance Testing (UAT).
• Sound experience in adhering to ETL standards and designing ETL process and ETL frameworks to help reusability.
• Well known skill for issue resolution till the closure.
• Good Team management capability.

TECHNICAL SKILLS:

ETL Tool: Informatica PowerCenter 9.5.1 /9.1.1 / 8.6

Database: Oracle 9i / 10g / 11g proficiency

Tools: Informatica PowerCenter Suite 9.5.1, Toad, SQL Developer, Putty, PL/SQL Developer

Operating Systems: UNIX, Windows XP, Windows 7

Version Control: Rational Clearcase, Tortoise SVN, Microsoft Visual Source Safe

Scripting: Basic Python & Unix Shell scripting

Informatica Certified Specialist

Analytical Problem Solving Capabilities

Bug Reporting Tools: HP Quality Center, Excel

Languages: C, C++, Java Basics, Javascript, SQL

Job Scheduler: Informatica inbuilt, $Universe, CA ESP scheduler

Change Data Capture (CDC)

Big Data tools: HIVE

PROFESSIONAL EXPERIENCE:

Confidential, Menlo Park

Senior ETL Engineer

Responsibilities:

• As a data engineer, we need to understand the full stack of data where it gets generated and where does it flow and there by gather it from required sources.
• Gather the data and write code to transform the data into required format and then write to Vertica database for analytic purposes.
• Implement data quality rules for the incoming data from several sources and also maintain non-redundant data.
• Design database tables to customize the meaning of user data and to be utilized for many purposes.

Solution Environment: Personal Devservers managed by Chef, Framework fully custom built using Python, Informatica PowerCenter 9.6 for salesforce sources, UNIX, Vertica 7.x Analytics Database, Chronos as a job scheduling custom built product, Git + SVN source code control inbuilt into Dev Servers, Tableau & Micro Strategy for reports and dashboards, Informatica developer for Data Quality management.

Confidential

Lead Consultant Developer

Responsibilities:

• As a senior developer, responsibilities include discussion with business managers and take the required inputs as per the requirement.
• Assigning tasks to the respective individual team members based on the required deliverables to satisfy a lead responsibility.
• Extensively involved in developing the ETL logic to do the Auditing and Error Handling for the loads happening across different projects using Informatica PowerCenter.
• Code and automate several archival mechanisms and dynamic file changing using Python.
• Passionately drive the development and give the top notch delivery.
• Developed the ETL code in Informatica PowerCenter and also have tested ETL datawarehouse components.
• Test results to be captured and documented thoroughly.
• To contribute to daily work by understanding new requirements and also ensure data quality with minimum checks .
• Review the code developed by other team members.
• Suggest any performance oriented approaches as applicable.
• Always deliver and stay on top of Informatica PowerCenter development and support related issues.

Solution Environment: Windows 7, Informatica PowerCenter 9.5, UNIX, Oracle SQL, Informatica Data Quality.

Confidential

Sr. Informatica Developer

Responsibilities:

• To interact with Client directly and discuss any on-going issues and provide guaranteed solutions that are destined to work.
• Discuss with team and get the doubts clarified before going to start their daily activities.
• Assigning tasks to the respective individual team members based on the required deliverables.
• Used Python to validate several user files and organize them in specific area according to business requirements.
• Involved in improving the QA Process.
• To use Python coding for effective looping and development of different reusable portable scripts.

Solution Environment: Windows XP, Informatica PowerCenter 9.1, UNIX, Oracle SQL, Informatica Data Quality.

Confidential

Sr.Informatica Developer

Responsibilities:

• Understanding the business requirement and the functional requirements.
• Extensively worked in data Extraction, Transformations and Loading from different source system and manipulated ETL-logic to Target system tables
• Developed PL/SQL Procedures and packages and using in informatica pre/post session routines SQL for metrics calculation.
• Created command tasks using informatica powercenter workflow-designer and execute the corresponding Python scripts.
• Used Informatica PowerCenter for Extraction, Loading and Transformation(ETL) of data in the data warehouse.

Solution Environment: Windows XP, Informatica PowerCenter 8.6, Oracle SQL, UNIX, $Universe Scheduler, Enterprise Turn Point, Teradata 13.0.

Confidential

Informatica Developer

Solution Environment: Windows XP, Vista, SQL, UNIX, Informatica PowerCenter 8.1, 8.6

Confidential

Informatica Developer

Responsibilities:

• Used Informatica PowerCenter for Extraction, Loading and Transformation (ETL) of data in the data warehouse.
• Used most of the Transformations such as Source Qualifier, Aggregator, lookup, Filter, Joiner, Sequence generator, Router, update strategy etc.
• Used session parameters, Mapping variable/parameters and created parameter files for flexible runs of workflows based on changing variable values.
• Involved in Optimizing and performance tuning logic on targets, sources, mappings, and sessions to increase the efficiency of session.
• Reloading data for failed Informatica PowerCenter workflows and finding out RCA.

Solution Environment: Windows XP, Vista, Informatica PowerCenter 8.6, PL/SQL, UNIX basics

Confidential

Informatica Developer

Responsibilities:

• Used Informatica PowerCenter for Extraction, Loading and Transformation (ETL) of data in the data warehouse.
• Used most of the Transformations such as Source Qualifier, Aggregator, lookup, Filter, Joiner, Sequence generator, Router, update strategy etc.

Solution Environment: Oracle 9i SQL, PL/SQL, UNIX, Informatica Basic transformations.