SUMMARY

• Around eight years of expertise in data warehousing projects including Data Integration, Data Migration and Data Enablement using Informatica as the ETL tool
• 4+ years of expertise in leading the ETL projects through all phases of SDLC right from requirements elicitation till production support
• Proficiency in designing and implementing Optimized, high quality and robust ETLS to meet the business requirements
• In depth understanding of Enterprise Data Warehouse Architecture, concepts of data warehouse modeling approaches Confidential dimensional modeling and Inmon’s normalized data model and good exposure to the Data Vault modeling, a database modeling method
• Extensive experience in working with Informatica power center along with relational databases Oracle, Teradata and heterogeneous data sources including FLAT files, Excels and XML
• Hands on experience with Informatica Cloud and other ETL tools like Business Objects Data Services and Open Source ETL tool Pentaho
• Exposure to Informatica Data Quality Analyst and Developer
• Good understanding of Teradata Architecture
• Strong in analyzing and writing complex queries using SQL in Oracle and Teradata
• Expertise in Job scheduling tool $U(Dollar Universe) and exposure to DAC, Autosys
• Good exposure to UNIX Shell scripts, Linux
• Well versed with performance tuning for ETLS and SQLs in Oracle and Teradata
• Extensive experience in implementing projects using Agile(kanban) and waterfall methodologies
• Expertise in detail oriented documentations and converting the Business requirements into technical design documents
• Well recognized for the high quality deliverables
• Good at gaining functional knowledge. Worked as SME for few modules in Revenue Management
• Strong analytical, debugging and problem solving skills to undertake challenging jobs
• Excellent communication skills and abilities to interact with various cross functional teams including business teams to ensure the successful delivery of the projects
• Quick adaptability to new, emerging technologies with abilities to work as a good independent player and a very good team player as well

TECHNICAL SKILLS

ETL Tools : Informatica 8.6/9.5, BODS, Pentaho, Informatica Cloud

Data Quality Tools: IDQ Analyst, Developer

RDBMS Tools : Toad, SQL Assistant, SQL Developer

RDBMS : Oracle9i/10g/11g/R12, Teradata

Version Control Tools: PVCS, SVN

Deployment Tool: Kintana, ICART

Job Scheduling Tools: Dollar Universe, DAC,Autosys

Scripting Languages: Unix Shell Script, Linux Scripting

PROFESSIONAL EXPERIENCE

Sr. Informatica Developer

Confidential, Herndon, VA

Responsibilities:

• Elicitation of requirements
• Review the requirements from business
• Source system analysis
• High level and Detail level designing
• Designing ETLs as per the business requirements
• Development and review of ETLs
• Resolve performance bottlenecks by optimizing the mappings, sessions and workflows
• Development of JILs in Autosys to schedule the jobs
• Testing the ETLs and Autosys jobs
• Build and deployment of baselines to higher environments
• Support SIT and UAT phases
• Ensuring successful delivery of the project within the timelines defined

Environment: Informatica Power center, Informatica IDQ Analyst, IDQ Developer, Oracle, Unix, BO, EDW, Autosys, SVN, ICART

Sr. Informatica Developer

Confidential, Herndon, VA

Responsibilities:

• Elicitation of requirements
• Review the requirements from business
• Source system analysis
• High level and Detail level designing
• Designing ETLs as per the business requirements
• Development and review of ETLs
• Resolve performance bottlenecks by optimizing the mappings, sessions and workflows
• Development of JILs in Autosys to schedule the jobs
• Testing the ETLs and Autosys jobs
• Build and deployment of baselines to higher environments
• Support SIT and UAT phases
• Ensuring successful delivery of the project within the timelines defined

Environment: Informatica Power center, Informatica IDQ Analyst, IDQ Developer, Oracle, Unix, BO, EDW, Autosys, SVN, ICART

Sr. Informatica Developer

Confidential, Herndon, VA

Responsibilities:

• Elicitation of requirements
• Review the requirements from business
• Source system analysis
• High level and Detail level designing
• Designing ETLs as per the business requirements
• Development and review of ETLs
• Resolve performance bottlenecks by optimizing the mappings, sessions and workflows
• Development of JILs in Autosys to schedule the jobs
• Testing the ETLs and Autosys jobs
• Build and deployment of baselines to higher environments
• Support SIT and UAT phases
• Ensuring successful delivery of the project within the timelines defined

Environment: Informatica Power center, Informatica IDQ Analyst, IDQ Developer, Oracle, Unix, BO, EDW, Autosys, SVN, ICART

Sr. Business Intelligence Engineer

Confidential, Raleigh, NC

Responsibilities:

• Interaction with business team for the elicitation of requirements
• Source system Analysis
• Impact Analysis
• Designing ETLs as per the business requirements
• Development of ETLs
• Implementation of Change Data Capture (CDC) for slowly changing dimensions (SCD type1,type2 and type3) preparation of unit test case documents
• Unit testing at various levels of the ETLs
• Scheduling ETLs in the job scheduling tool DAC
• Testing the Scheduled jobs
• Code Reviews
• Root Cause Analysis and resolution of the issues in Production
• Resolve performance bottlenecks by optimizing the mappings, sessions and workflows

Environment: Informatica, BODS, Pentaho, Infomatica Cloud, Oracle, Linux, BO, EDW, BAW, Data Vault, DAC.