We provide IT Staff Augmentation Services!

Informatica Tech Lead Resume

NewarK

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

Hire Now