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.
Sr. Executive Support at Cognizant technology Solutions, Cognizant Technology SolutionsSr. Executive Support at Cognizant technology Solutions, Cognizant Technology Solutions