SUMMARY:

• Well qualified and a seasoned professional holding 9 years of experience in the areas of Data Warehousing, Business Intelligence & ETL with extensive knowledge in OLAP, OLTP and Data Quality concepts.
• Experience in latest ETL project management trends and expertise in analyzing requirements, designing functional specifications and providing solution architecture.
• Performed various client facing and client representative positions including Business & Data Analyst, Technical Lead, Data Warehouse Consultant & Architect.
• Capable of independently reviewing existing data model with all stakeholders such as Enterprise Architects, Solution Architects, Informatica Developers, Business Users and provided solutions to issues/modifications.
• Performed development based on established best practices from Organization’s Center of Excellence project documents.
• Experience in synergizing the onshore and offshore teams (both India & US) to build ETL applications.
• Expertise in leveraging solid oral and written communication skills in crafting Technical Requirement Document and ETL specification document for application development.

TECHNICAL PROFICIENCY:

Databases & Tools: Oracle, Teradata, Mongo & Informatica Power center 9.1/10.1, Informatica IDQ 9.1/10.1, Informatica DIH 10.1.1, Hive

Programming Languages: Shell scripting

Technology: Amazon S3, Postman, API Calls, XML, JSON, Web Services

Other Utilities: Putty, Winscp

CAREER PROGRESSION:

Confidential, Newark

Tools& Technology: Informatica Power center 10.1, Informatica IDQ 10.1, Informatica DIH 10.1.1, Web services, JSON, XML, API, Postman, Amazon S3, Oracle, Teradata, Mongo DB, Hive

Informatica Tech Lead

Responsibilities

• Work closely with the business users in evaluating the existing data model, defining the data extraction strategy, designing the Request & Response layer and building a new data model
• Lead project design and architecture activities and interact with the team for technical review sessions and acquiring approvals; collaborate with business users during initial project analysis and data discovery, performing map and gap analysis and training business users
• Guide the offshore teams in architecting building blocks and ensuring that the layer - built extracts the complete set of files for the downstream interfaces
• Develop Extract, Transform & Load (ETL) mapping as per business requirement, SQL queries to perform audit between source, staging, and target data
• Accountable for error validation, generating count statistics and creating reusable mapplets, transformations, and scripts
• Create and validate deployment-checklist necessary to verify the seamless migration of components to various repositories
• Invoke Request & Response Daily Load runs to ensure that all the data are loaded completely within the SLA, prioritizing and resolving issues if any, with the concurrence of Database& Informatica Administrators
• Monitor the database environment, identify performance, trends and develop meaningful reporting, metrics and trending documentation to develop action plans
• Share the daily status of load runs and incident management tickets which were opened in SharePoint during regular calls

Confidential, New Jersey

Tools& Technology: Informatica Power center 9.1, Oracle, Shell Scripting, Web services

Offshore Tech Lead

Responsibilities

• Responsible for engaging with SMEs to gather & organize a wide range of data and insights, develop Business Requirement Document (BRD) and converting BRD into Technical Requirement Document
• Collaborate with Business Analyst and Data Architect to finalize the Technical Requirement Document and with Data Modeler to update/modify existing data model for Confidential
• Coordinate with SQA Team in understanding bugs/defects during testing and production runs; deliver temporary/permanent fixes and offer status updates during daily vendor calls
• Interact closely with the Database & Informatica Administrators on issues related to environment and resolve them in a time bound manner
• Provide ongoing performance monitoring, tuning, and automation of production activities related to the application
• Serve as a project manager when required, coordinating resources, developing project plans, and ensuring the accuracy and timeliness of work performed by the project team
• Responsible for submission of daily, weekly and monthly status reports and participation in triage calls

Confidential, New Jersey

Tools& Technology: Informatica Power center 9.1, Oracle, Shell Scripting, Web services

Senior Developer

Responsibilities

• Contributed substantially towards Technical Design Document for ETL interfaces
• Designing and developing mapping using client hosted Informatica Power Centre Tool
• End to End ETL Testing
• ETL Monitoring
• Resolving logical and business issues

Confidential

Systems Engineer

Tools & Technology: Informatica Power center 9.1, Oracle, Shell Scripting

Responsibilities:

• Data Migration strategy is to develop re-usable migration package to support the data migration from Active learner data model to the Plateau data model for multi-go live implementation
• Involved in managing the complete scope of Extract, Transform & Load, testing and supporting the applications
• Develop process jobs as per design, prepare unit test cases, prepare test data and Perform unit testing

Confidential

Tools & Technology: Informatica Power center 9.1, Oracle, Shell Scripting

ETL Developer

Responsibilities:

• Involved in managing the complete scope of Extract, Transform & Load, testing and supporting the applications
• Develop process jobs as per design, prepare unit test cases, prepare test data and Perform unit testing
• ETL Monitoring
• Resolving logical and business issues