Summary
Overview
Work History
Education
Skills
Languages
Certification
Timeline
Generic
Aakash Teotia

Aakash Teotia

Noida

Summary

  • Software Professional with 13 years of experience who has worked extensively on ETL-Informatica Powercenter, Intelligent Data Management Cloud (IDMC), Oracle SQL, PL/SQL.
  • A data integration and data warehousing expert in ETL tools such as Informatica PowerCenter, IICS(CDI), along with SQL and PL/SQL.
  • Expertise in designing and creating entire ETL mappings and transformations using Informatica to move data from multiple sources (Databases, flat files, XML files, CSV files) to target using various transformations.
  • Highly skilled at problem solving, root cause analysis, and technical skills that enable effective business solutions which result in high customer satisfaction.
  • Ability to gain a deep understanding of new technologies and acquire functional/domain knowledge with minimal learning curves.
  • Creating packages and procedures on Oracle PL/SQL to achieve the underlying business logic.
  • Performance tuning of existing applications.
  • Client interaction for requirement gathering. Unit testing as well as system integration testing for the successful deployment of code in a live environment.
  • Assembles effective teams by exploiting complementary competencies and collaborative employee relationships.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Technical Lead

Cognizant Technology solutions
10.2022 - Current
  • Working as a Lead engineer on migration project where the client has planned to set up a future-ready cloud integration platform by migrating existing logic from On-premise Informatica Powercenter to the Intelligent Data Management Cloud (IDMC) platform to support the cloud initiative to modernize applications.
  • Used the Migration factory tool provided by Informatica to convert the existing on-prem code to IICS after completing a CDI modernization certification.
  • Migrated the database from Oracle to Snowflake.
  • Made the code changes and development in IICS using different transformations (eg. Sorter, filter, SQL, Router, lookup etc).
  • Used PL/SQL for the procedures and functions development and migration.
  • Control-m was used to automate the scheduling and execution of jobs and workflows across various platforms and applications.
  • Setting up a conversion platform by setting up AWS EC2 and other AWS services.
  • Provided educational expertise and mentoring to junior team members.
  • Supervised work of programmers, designers and technicians, assigned tasks and monitored performance against targets.

Senior ETL Developer

Global Payments
11.2019 - 10.2022
  • Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations.
  • Financial Infrastructure is the crux of financial systems. This system is responsible for processing of all transactions made on a particular day and settles the finances between banks, cardholders and distributors.
  • LEAN Project Implement Adjustment Hub platform to manage, streamline and better segment the dispute claim processing.
  • Requirements gathering from SME of different source systems.
  • Code development and support using Pl/Sql, Unix shell scripting and Tidal.
  • Provided logic change to the existing setup.
  • Provided fallout details for all non-matching records.
  • Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
  • Wrote and optimized in-application SQL statements.
  • Interpreted data models for conversion into ETL diagrams and code.

Senior Software Developer

CenturyLink Technologies
08.2015 - 07.2019
  • Worked as ETL (Informatica Powercenter) developer and Oracle PL/SQL developer.
  • Worked on the Project PCM (Probability and cost Management) where we capture revenue and expense information from different sources and builds a forecasting model which helps the company to estimate how much money is required to perform or carry out daily basis operations.

Software Developer

Nucleus Software Exports Ltd.
02.2012 - 04.2015
  • Documented software development methodologies in technical manuals to be used by IT personnel in future projects.
  • Developed the code written in SQL server to PL/SQL language.
  • Maintenance and support of the existing product through FinnOne LMS.
  • Created procedures, functions and Triggers to add some new functionality.
  • Loan management system manages all the transactions made between the bank and customer during the entire cycle of loan from the day a loan is disbursed to the customer till the loan maturity.
  • Worked on the client requirements and provided product support and managed the transactional data.
  • Created UNIX script to generate some exception.
  • Enhancement in existing reports.

Education

Bachelor of Technology - Computer Science

Vivekanand Institute of Technology & Science
Ghaziabad
04.2011

Skills

  • Informatica Powercenter
  • IICS/ IDMC
  • Oracle PL/SQL
  • SQL data analysis
  • UNIX
  • Tidal
  • Control-m
  • Snowflake

Languages

English
Hindi

Certification

Certified in Cloud Data Integration (CDI) Modernization certification from informatica.

Timeline

Technical Lead

Cognizant Technology solutions
10.2022 - Current

Senior ETL Developer

Global Payments
11.2019 - 10.2022

Senior Software Developer

CenturyLink Technologies
08.2015 - 07.2019

Software Developer

Nucleus Software Exports Ltd.
02.2012 - 04.2015

Bachelor of Technology - Computer Science

Vivekanand Institute of Technology & Science
Aakash Teotia