Summary
Overview
Work History
Education
Skills
Certification
Awards
Extracurricular Activities
Training
Languages
Personal Information
Websites
Accomplishments
Languages
Timeline
Generic

Amit Bhartiya

Pune

Summary

IDQ Developer with extensive experience at Infosys Ltd., specializing in data quality and governance. Expertise in Informatica Data Quality and Unix Shell Scripting, delivering solutions that enhance data integrity. Strong collaboration with cross-functional teams to drive successful project outcomes and implement innovative data management strategies.

Overview

13
13
years of professional experience
1
1
Certification

Work History

IDQ Developer/Admin

Synechron Technologies
07.2021 - Current
  • Working as a Data Quality lead and involved with direct client interactions and taking requirements
  • Profiling the source data to get the insights of source metadata characteristics and also for designing the rules
  • Understand the business requirement while serving as technical liaison between teams regarding new system implementations, development, integration, and changes while collaborating with management to design technical solutions
  • Responsible for developing Mappings, Mapplets and Rules using different types of transformations like Parser, Address Validator, Key Gen, Match etc
  • Transformations, created PDOs and LDO
  • Experience with extensive data analysis and data domain discovery using Profile, Scorecards, rules and SQL
  • Good Experience in implementation of data profiling, creating score cards, reference tables and documenting Data Quality metrics/dimensions like Accuracy, completeness, duplication, validity, consistency etc
  • Responsible to take care of all the IDQ admin related activities
  • Have recently done IDQ upgrade to 10.5.3 on 12 servers
  • Working on ingesting data from Data Lake and various other HUBs through the new era technologies like Elastic/Rest APIs and streaming data from IBM MQ
  • Good experience in writing UNIX shell scripts, SQL scripts for development, automation of ETL process, error handling and auditing purposes

IDQ/EDC/IGC/ORACLE EDQ Developer

Infosys Ltd.
08.2018 - 07.2021
  • Leading the data management and Governance team at Charles Schwab
  • Utilize IDQ for data discovery, standardization, and quality rule execution
  • Collaborate with business teams to understand requirements and implement data quality solutions
  • Used profiling capabilities to profile various sources, generate score cards, create and validate rules and provided data for business analysts for creating the rules
  • Used Informatica Data Quality transformations such as standardization, labeling, parsing, address validation, Matching, Rest Web Consumer, Consolidation, Association etc
  • To identify redundant and duplicate information and achieve MASTER record
  • Developing Rules, Profiles, Scorecards and Workflows in Informatica Data Quality tool as per the business requirements from the clients
  • Extensive usage of Rest Consumer Transformation to make Rest Calls to various sources
  • Defines and implements Data Governance Management tools (IBM IGC, Informatica EDC)
  • Develop data quality metrics that identify gaps and ensure compliance with standards across the organization
  • Managing all the Assets (Tables, columns, hosts, schema, databases, applications etc.) across the organizations
  • Working on automations through shell scripting and build complex scripts
  • Ingesting new data resources/scanners, creating/curating data domains, adding custom attributes
  • Worked on building lineages in EDC to import Informatica PowerCenter mappings in EDC
  • Integration of IDQ with EDC to fetch the metrics as a report

Cognizant Technology Solutions
08.2016 - 09.2018
  • Resolving Data Quality Issues raised by different users
  • Raising proactive issues and working towards maintaining data quality
  • Looking into Dashboard and Network KPI
  • Onsite Experience: (Jul 2017- Feb 2018)
  • Working as an onsite coordinator/lead for EDW data quality team
  • Worked closely with various teams like design, development, operations and delivery team in Agile Framework to deliver CRs as per the deadlines communicated to the business
  • Shared the responsibilities of a scrum master and headed the product backlog and grooming sessions and coordinated the delivery of CRs
  • Worked towards maintaining the data quality of many of the EDW subject areas and resolved many design and development issues through complex patches
  • Validation of all the CRs before getting deployed in production
  • Worked closely with the business teams in understanding business requirements and coming up with the solutions to various issues
  • Worked in the migration of CLDM7 to CLDM12 for the network subject areas

CAPGEMINI INDIA PVT. LTD.
01.2015 - 07.2016
  • Preparing Bteq’s, macros and monitoring FastLoad, Mload and TPT jobs
  • Preparing DDLs for new business requirement, choosing suitable PI, PPI and SI
  • Involved in data mapping documents and data modeling
  • Working on the semantic layer and application layer to design business views
  • Optimizing the queries on database side and query side
  • Prepared Data Transformation codes through Informatica data transformation studio
  • Developed mappings in Informatica to load the data from various sources using different transformations

Team Member

Tech Mahindra
06.2012 - 12.2014
  • Participated in Requirement Gathering, Business Analysis, User meetings, discussing the issues to be resolved and translating user inputs into ETL mapping documents
  • Implemented various Business Rules & logic at transformation stage and loading data into Data Warehouse
  • Developed complex mappings in Informatica to load the data from various sources using different transformations
  • Used a new Concept of Push Down Optimization (PDO) for performance tuning which saved the load time
  • Load the engine data in target Teradata table using Teradata script and Informatica
  • Writing Teradata scripts Bteq, FLoad, MLoad scripts to load the data into staging
  • Develop the ETL objects to load the data from staging table to target table through Informatica
  • Re-design of existing mappings to reduce the table lock
  • Worked on performance tuning measures through Teradata
  • Writing shell scripts to do initial data validation of the source file
  • Adding Join indexes and Collect Statistics to improve loading performance
  • Doing Performance, Unit, Integration Testing and prepare ETL documents
  • Weekly status meetings with customer on adherence to deliverables and challenges with other stakeholder

Education

B. E -

R.G.P.V
01.2011

12th -

I.I.P.S
01.2006

10th -

A.G.C.S
01.2004

Skills

  • Informatica Data Quality (IDQ)
  • Informatica EDC
  • Teradata
  • Oracle
  • Unix Shell Scripting
  • Informatica Power Center
  • MongoDB
  • IBM IGC
  • Oracle EDQ
  • GCP
  • AWS
  • Cognos
  • Tableau
  • Wherescape RED
  • SVN
  • Bit Bucket
  • GIT
  • WinSCP
  • Putty
  • Control-M
  • Crontab
  • ESP

Certification

  • Teradata Certified Professional (TE0-121)
  • Teradata Certified Professional (TE0-141)
  • Google Cloud Certified Associate Cloud Engineer (GCP) (ID:33df92b33135496e8bc6d9d9ddd6a73b)
  • AWS certified DEVOPS Professional

Awards

  • Got Star Award in Synechron from last two years.
  • Got EOM (Employee of the Month) Award at Synechron.
  • Got EDW achievement award at Onsite for all round contribution in the Scrum Team.
  • LOA from STC client for work towards maintaining data quality.
  • Got customer appreciation twice in the same financial year.
  • Got LOA (Letter of Appreciation) for securing 90% in a case study during training.
  • Got POB (Pat on Back) reward for implementing Wherescape in EDW project.
  • Got Certificate of Appreciation from CPO for contribution towards learning.

Extracurricular Activities

Actively participated in CSR (Corporate Social Responsibility) activities. Participated and won different activities like Cricket, Badminton, Kite Flying, Cooking competitions at Tech Mahindra.

Training

Mahindra Satyam, 06/01/12 - 09/30/12, MSLW – ELP Trainee, Trained for 3 months on Data Structures, RDBMS, ORACLE 10g, SQL, PLSQL, Software Engineering, Informatica8.6 and Cognos 8.4., Worked on case lets and case studies on SQL/PLSQL, Informatica and Cognos.

Languages

  • English
  • Hindi
  • Bhojpuri

Personal Information

Date of Birth: 09/03/89

Accomplishments

  • I have received the Star Award at Synechron for the last two years
  • I got the EOM (Employee of the Month) award at Synechron
  • I received the EDW Achievement Award onsite for my all-around contribution to the Scrum team
  • Letter of appreciation from the Saudi Telecom client for work toward maintaining data quality

Languages

Hindi
First Language
English
Proficient (C2)
C2

Timeline

IDQ Developer/Admin

Synechron Technologies
07.2021 - Current

IDQ/EDC/IGC/ORACLE EDQ Developer

Infosys Ltd.
08.2018 - 07.2021

Cognizant Technology Solutions
08.2016 - 09.2018

CAPGEMINI INDIA PVT. LTD.
01.2015 - 07.2016

Team Member

Tech Mahindra
06.2012 - 12.2014

B. E -

R.G.P.V

12th -

I.I.P.S

10th -

A.G.C.S
Amit Bhartiya