SUMMARY:

• Confidential have 12 years of experience in data warehousing in software development, maintenance and team management. Confidential was involved in the various life cycles of software development including requirements gathering till maintenance and support.
• Main development experience is with tools Informatica Power center and Informatica BDM and Databases Oracle,MS SQLServer, Teradata and Big data Hadoop and Hive Tools.
• He is good at writing complex queries, performance tuning, and Impact analysis and debugging.
• Have good expertise in Informatica, Oracle,Teradata,Bigdata tools and was part of a team who built warehouse in Teradata and implemented complex mappings which was part of a General Electrical( Confidential ) project from Oracle to Teradata in prior project.
• Strong knowledge of data warehouse design and build concepts and skilled at analyzing business requirements and preparing high level and detailed designs.
• Have exposures in domains like Health care,Lifescience Insurance,Finanace.
• Have prior experience working in the onsite - offshore model, interaction with clients, monitoring work and status reporting.
• Good knowledge in data warehouse concepts and architecture
• Expert in ETL tools Informatica Power Center and Informatica BDM
• Proficient in databases Teradata, Oracle, SQL server, Netezza,Hive,
• Expert in analyzing and writing queries in Oracle and Teradata and Hive.
• In current data warehousing concepts (using technologies like Hive, Hadoop, etc to support business-driven decision)
• Prior experience in the role of ETL Architect
• Agile Project Expert

TECHNICAL SKILLS

ETL Tool: Informatica 10.2, Informatica BDM 10.2

Big Data: Hadoop, Hive, Pig, Ambari, Informatica BDM

Programming Languages: SQL, C, C++, Java

Database: Teradata, Oracle, SQL Server, Netezza,HBase,Redshift

Operating Systems: Windows, Unix

Scheduling Tool: Autosys, Control-M, Tidal

PROFESSIONAL EXPERIENCE:

Confidential, Denver, Colorado

ETL Architect and Team Lead

SPECIFIC SKILLS: Informatica, Oracle, MS SQL, Informatica BDM,Big data (Hadoop,Hive,Sqoop,Pig,Spark,HBase)

Responsibilities:

• Responsible for ETL Architect.
• Responsible for ETL Design of loads
• Analysing and Solving the Techno Functional Issues of the project.
• Designing ETL loads for loading Health care data from different source system to final IDS warehouse.
• Developed ETL codes in Informatica.
• Worked with different teams like, TIBCO, foundations to develop, daily, weekly and monthly loads.
• Working on RCA (Root Cause Analysis) for repeated issues.
• Interacting and co-coordinating with various teams to ensure smooth run of inbound and outbound interfaces without any issue
• Supporting / resolving the Issues reported by users on various modules.
• Deploying the bug fixes to production
• Ensuring smooth month close by resolving close critical issues.
• Training / helping new team members for resolving the issues.
• Agile development Life Cycle model and Water fall life cycle project model worked.
• Infromatica BDM mapping worked it Using Hadoop cluster and loaded Hive database.

Confidential, Newark, NJ

Team Lead

SPECIFIC SKILLS: Informatica,Teradata,Oracle, Netezza

Responsibilities:

• Responsible for ETL Design of loads
• Analysing and Solving the Techno Functional Issues of the project.
• Designing ETL loads for loading media data from Arbitron warehouse to MCH.
• Developed codes in Teradata and Informatica
• Worked with different teams like, foundations to develop, daily, weekly and monthly loads.
• Working on RCA (Root Cause Analysis) for repeated issues.
• Interacting and co-coordinating with various teams to ensure smooth run of inbound and outbound interfaces without any issue
• Supporting / resolving the Issues reported by users on various modules.
• Deploying the bug fixes to production
• Ensuring smooth month close by resolving close critical issues.

Confidential

Team Member

SPECIFIC SKILLS: Informatica, Oracle,Teradata

Responsibilities:

• Developing the mappings using needed Transformations in Informatica tool according to technical specifications
• Understanding the business requirement and preparing the low level and detailed design document.
• Responsible for ETL Development of loads
• Analysing and Solving the Techno Functional Issues of the project.
• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process
• Co-coordinating with users for UAT and addressing their concerns or issues.

Confidential, Norwalk, Connecticut

Team Member

SPECIFIC SKILLS: Informatica, Teradata,Oracle

Responsibilities:

• Understanding the business requirement and preparing the low level and detailed design document.
• Responsible for ETL Development of loads
• Analysing the existing system and prepared Impact Analysis Document.
• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process
• Provided warranty support after the code was deployed to production.
• The objective is to extract data stored in different databases such as Oracle, TERADATA and to load finally into a single data warehouse repository, which is in TERADATA.
• Designed mapping as per ETL Specifications.
• Developed mapping and tuned them for better performance.
• Performed data validation and integrity checks to see that data is loaded as per requirements and mapping logic.