Satyam Jha
Data Engineer
Mumbai
Summary
Detail-oriented Data Engineer with 5+ years of hands-on experience in designing and optimizing ETL workflows, MDM solutions, and data pipelines using Informatica (PowerCenter, IICS, MDM), SQL, and UNIX. Skilled in performance tuning, data quality, and automation, with a strong focus on delivering scalable and reliable data integration solutions. A skillful and collaborative team player committed to delivering high quality solutions.
Overview
5
5
years of professional experience
4
4
Certifications
3
3
Languages
Work History
Data Engineer
TATA CONSULTANCY SERVICES LTD.
03.2021 - Current
- Designed and developed ETL mappings and workflows using Informatica PowerCenter and IICS for end-to-end data integration across multiple source systems.
- Implemented Informatica MDM Hub configurations, including landing, staging, base objects, match and merge rules, and trust/survivorship logic.
- Developed custom user exits, match rules, and SIF APIs for complex business scenarios in MDM.
- Optimized 200+ SQL queries to improve performance by 90%, which ensured smooth performance of ETLs and MDM solutions.
- Designed and configured the IDD (Informatica Data Director) user interface for data stewardship tasks, such as merge, unmerge, and manual overrides.
- Conducted data profiling, cleansing, and validation using Informatica DQ and SQL, Pandas to ensure data accuracy and completeness.
- Collaborated with business analysts to gather data requirements and translate them into scalable ETL, and MDM solutions.
- Optimized ETL jobs, bringing down run time by 99%, resulting in better data processing and data operations.
- Built and maintained database objects (views, procedures, indexes) in Oracle, SQL Server, and PostgreSQL to support integration and reporting needs.
- Scheduled and monitored ETL jobs using workflow managers and job schedulers, like Control-M.
- Participated in unit testing, integration testing, and supported UAT, and production deployments.
- Implemented SCD2, SCD3 logic to manage historical data as per the requirements discussed to ensure data accuracy and completeness.
- Developed and optimized ETL workflows, leveraging UNIX shell scripting for automation, scheduling, and data pipeline orchestration.
- Implemented data quality checks and a governance framework that reduced duplicate records by 30%.
- Awarded performance recognition for contributions in improving ETL performance tuning. Worked on MD5 hash to filter out updates into the target based on the requirements.
Java Developer
TCS
08.2020 - 03.2021
- Developed and maintained full-stack web application features using Java and Angular, ensuring a scalable and responsive UI/UX.
- Designed and implemented RESTful APIs for seamless communication between front-end and back-end services.
- Integrated database operations with Java for efficient data retrieval, transformation, and persistence.
- Collaborated with cross-functional teams in Agile sprints, handling requirements, development, testing, and deployment.
- Optimized code and performed debugging to enhance the performance, reliability, and maintainability of the application.
Education
Bachelor of Science - INFORMATION AND TECHNOLOGY
Patkar Varde College
Mumbai, Maharashtra10-2020
Skills
Informatica Power center
SQL
Informatica Intelligent Cloud Services (IICS)
Python with AI
Power BI
Pandas (Basics)
DEVOPS
Informatica MDM
GITLAB
Data Warehousing
Oracle
Data Modelling
Postgres
UNIX
Match & Merge Rules
Query optimization
Trust/Survivorship
JAVA (Basic)
Data Stewardship (IDD UI)
AWS (Basic)
KAFKA (BASIC)
JIRA,JILE
Data governance
Problem-solving abilities
Certification
Certificates
Marital Status:
Single.
Timeline
Data Engineer
TATA CONSULTANCY SERVICES LTD.
03.2021 - Current
Java Developer
TCS
08.2020 - 03.2021
Bachelor of Science - INFORMATION AND TECHNOLOGY
Patkar Varde College
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Hardik ShahHardik Shah
Representative - South Asia at EHL Hospitality Business SchoolRepresentative - South Asia at EHL Hospitality Business School