Summary
Overview
Work History
Education
Skills
Timeline
Generic

Nitesh Kumar

Summary

To achieve a rewarding and challenging position in the field of Computer Engineering and coordinate with a team of highly experienced professionals for my personal as well as corporate growth. PROFESSIONAL SUMMARY 8+ years of IT Experience in development of Data warehousing solutions using Informatica Power Center, Informatica Data Quality 10.4 Deft in managing complete SDLC with technical expertise in Informatica, SQL, UNIX Shell Scripting Good understanding of Data warehousing and ETL concepts. Sound knowledge of Star, Snowflake Schema Designs Good Experience in understanding business application, business dataflow and data relation. Experience in integration of various data source definitions like Oracle, SQL Server, MySQL, Flat Files Experience in designing and developing mappings from varied transformation logic like Source Qualifier, Filter, Router, Expression, Aggregator, Joiner, Update Strategy, Unconnected/Connected lookups etc. Experience in developing Workflows, sessions, tasks to effectively manage the Load Knowledge of Informatica CDC Workflows Involved in knowledge sharing and knowledge transfer to the new members of the project & Preparation of knowledge transfer documents Excellent problem-solving skills with a strong technical background and result oriented altruist with excellent communication and interpersonal skills Extensively used ETL methodology for supporting Data Extraction, Transformation and Loading processing, in a corporate-wide-ETL Solution using Informatica

Overview

8
8
years of professional experience
1
1
Language

Work History

Lead

Apar Technologies, Equinix Inc
  • Data Operations Team
  • Roles & Responsibilities:
  • Worked on creating an ETL solution using the Informatica Power Center, Informatica Data Quality, Control-M metadata tables respectively to capture run time dynamics
  • Worked on moving the historical data from Exasol snapshot table to Big Query in GCP
  • Created Stored Procedure to provide alerts for all the long running/delayed jobs
  • Working on configuration of new environment in GCP
  • Used Informatica Data Quality to mitigate the DQ issues in product marketing data at Equinix
  • Reviewing and approving the merge requests in GITHUB and delegating tasks to the team members.

SQL/ETL Developer

HCL Technologies
11.2021 - Current
  • Understanding existing business model and client requirements
  • Analyzing the requirement Documents
  • Working in Agile model, participating in daily stand-up calls and sprint planning, review and retrospection at the beginning and end of each sprint, respectively
  • Working as an ETL developer, developed various Informatica Mappings, Mapplet and Transformations for migration of data from various existing systems to the Data warehouse using Informatica Designer
  • Used most of the transformations such as the Source Qualifier, Expression, Update strategy, Lookup, Filter etc
  • Used Pre-and Post-Session SQL statements
  • Responsible for monitoring all the sessions that are running, scheduled, completed, and failed
  • Debugged the mapping of the failed sessions
  • Involved in Unit Test Case preparation and did the unit testing.

Apar Technologies
07.2020 - 11.2021

Contributor

Microchip Technology Inc
05.2018 - 06.2020
  • Domain: Supply Chain Management Role: Individual, Roles & Responsibilities:
  • Working on creation of ETL solution to feed data to Adexa – Supply chain Planner
  • Worked directly with the business users at the On-shore office to understand the as is process
  • Migrated multiple projects to Informatica for the existing manual process by the Business users
  • Handling Supply chain solutions and working closely with the backend operations team
  • Moving the business extracts out of legacy ERP systems like Baan to Informatica
  • Worked with CDC tables being replicated from Attunity
  • Providing a robust mechanism and a quicker turnaround for supply chain process.

Informatica Developer

Zyme Solutions
01.2017 - 05.2018
  • Working on a new project in the company to embed all the backend CDM activities on the UI
  • Using Informatica Power center 10.1 to make REST API call and pass signals via JSON to the UI
  • Utilizing various mappings, mapplets and Shared objects in INFA to code the existing logic
  • Working on AUL, in correspondence to the data reported by the partners
  • Working with MDM and generating feed outs for the OEMs
  • Enabling visibility to all the existing feed outs and reports being generated.

Technical Lead

HCL Technologies
08.2014 - 12.2016
  • Working on the performance enhancement of existing ETL Data pipelines built for Business Managed Data.

Education

bachelor’s - computer science

Lovely Professional University

Skills

TECHNICAL SKILLSundefined

Timeline

SQL/ETL Developer

HCL Technologies
11.2021 - Current

Apar Technologies
07.2020 - 11.2021

Contributor

Microchip Technology Inc
05.2018 - 06.2020

Informatica Developer

Zyme Solutions
01.2017 - 05.2018

Technical Lead

HCL Technologies
08.2014 - 12.2016

Lead

Apar Technologies, Equinix Inc

bachelor’s - computer science

Lovely Professional University
Nitesh Kumar