Sachin Pawar
Thane
Summary
Data Engineer with 3+ years of experience in ETL development and database management, specializing in the Insurance domain. Skilled in using ETL tools like Informatica PowerCenter and Pentaho, with expertise in creating dynamic, generic, and SCD1/SCD2 mappings. Proficient in AWS (EC2, S3, IAM, VPC, Route 53) and handling structured and unstructured data sources. Strong knowledge of SQL, Unix commands, and dimensional modeling (Star and Snowflake schema). Experienced in technical documentation, requirement analysis.
Overview
3
3
years of professional experience
Work History
Data Engineer
Paramount Healthcare management
Thane
01.2023 - Current
- Extracted and transformed data from multiple sources (databases, flat files, Excel) using Informatica PowerCenter to meet business requirements.
- Utilized a variety of Informatica transformations, including Filter, Expression, Lookup (Connected/Unconnected), Aggregate, Update Strategy, Normalizer, Joiner, Router, and Union, for data manipulation.
- Crafted complex SQL queries using joins, subqueries, CTEs, aggregate, and analytical functions (DDL, DML, TCL) for efficient data extraction and transformation.
- Debugged ETL mappings and utilized session logs to identify and resolve issues during data loading.
- Performance tuning by optimizing mappings, sessions, and improving job execution time.
- Developed and implemented complex mappings to load data into staging and dimension tables, following business logic and data modeling best practices.
- Applied data modeling techniques (Star and Snowflake schema) for efficient database design.
- Enhanced existing jobs and transformations to improve performance and integrate new features.
- Created a job control framework to monitor and track daily incremental job statuses.
- Worked with Pentaho Data Integration (PDI) to perform data manipulations using transformations like Filter Rows, Calculator, Group By, Update, Row Normalizer, Join, Router, and Union.
- Scheduled ETL jobs using Task Scheduler and batch files to automate data workflows.
Database Developer
Tectigon IT Solutions Pvt.Ltd
Pune
10.2021 - 01.2023
- Design and develop databases to store and organize large amounts of data.
- Worked on DDL, DML, and TCL commands.
- Create and maintain database objects, such as tables, views, and indexes.
- Develop and implement database security measures, like constraints.
- Monitor database usage and optimize queries for better performance.
Education
Bachelor of Science -
Dr. BSKKV
Dapoli01.2019
Skills
- ETL Tools: Informatica PowerCenter, Pentaho Data Integration
- Databases: Oracle, PostgreSQL
- Scripting: Advanced SQL queries and optimization, UNIX Shell scripting
- Cloud Platform: AWS (EC2, VPC, S3, RDS, IAM, CloudTrail, Route 53, ELB, Auto Scaling)
- DevOps Tools: Git, Docker
- Data modeling
- Data Integration: Data Extraction, Data Transformation, Data Loading
- ETL development
- Team Management
Timeline
Data Engineer
Paramount Healthcare management
01.2023 - Current
Database Developer
Tectigon IT Solutions Pvt.Ltd
10.2021 - 01.2023
Bachelor of Science -
Dr. BSKKV
Similar Profiles
Edgardo LópezEdgardo López
Country Manager & Business Development Manager at Paramount Management Group LLCCountry Manager & Business Development Manager at Paramount Management Group LLC
Maya FuentesMaya Fuentes
SVP M&A Business Development at Paramount Management GroupSVP M&A Business Development at Paramount Management Group
Veronika WhiteVeronika White
Project Specialist, Operations at Paramount Management GroupProject Specialist, Operations at Paramount Management Group