Data Engineer at ScatterPie Analytics (2025-01 – Present)
Working as a Data Engineer in ScatterPie Analytics.
ETL Developer at Ultraskills IT solutions (2021-11 – 2024-12)
Data Engineer at Quess Corp (2025-01 – Present)
BI_TRANSITION project - Development and Support in Finance industry
- Involved in discussions with business users to understand the Business requirement.
- Did analyzed the Source data and validated against the business requirement. Given suggestion to source team, requested the missing data.
- Created different pipelines for the implementing the star schema to implement the different KPIS.
- Conducted comprehensive data analysis in MySQL, identifying KPIs, uncovering outliers, and providing actionable insights to influence business strategies and operational decisions.
- Used custom SQL in ETL to do data transformations such as filter, Joins etc.
- Managed data loading processes in the UAT environment, ensuring smooth transitions from development to testing
- Worked in UAT environment for validation of the data to resolve the user's query.
- Created Technical design document, and took the client sign off on the same.
- Developed and maintained schemas, creating mapping sheets as per data models in collaboration with tech architects
- Built and managed ETL pipelines, loading data into Snowflake, and creating interfaces for raw & stage layers
- Developed scalable ingestion Taskflow to extract structured data from Oracle, PostgreSQL, MS SQL, and SharePoint Lists
- Converted complex Qlik ETL scripts and Oracle SQL queries into optimized Snowflake-compatible codes
- Designed and implemented mapping for efficient data transformation, with automated daily execution to ensure timely loading into target tables.
- Building data mart and Star Schema using IICS and Snowflake.
- Scheduled ingestion and ETL pipelines using Stonebranch, monitored ETL jobs, and debugged errors
- Addressed customer concerns, provided ad-hoc mapping refinements, and ensured data quality
- Deployed code to QA and production environments using GIT and Jenkins
- Helped on Post Deployment issues, Production Maintenance issues
ETL Development at SBI (2023-08 – 2024-12)
WMP project - Development and Support in Banking industry
- Worked on development and support activities.
- Extraction of source file/database data and load the data in data warehouse.
- Development of mappings, sessions, workflow etc. as per design.
- Worked on all of the design phases (Staging, SNAP, Business and Dimensional layer)
- Worked on creation of mappings for different dimension and fact table.
- Worked on extract generation for the transaction details.
- Worked as SPOC for deployment activities
- Used different transformation for implementing SCD1, SCD2 logics.
- Coding (Implementation of business requirement through Informatica) and Unit Testing
- Developed the UNIX Scripts to transfer the Files
- Worked on all the layer of the Architecture
- Worked on Peer review.
- Doing the data load in UAT environment and data validation
- Involved in support of the Application.
ETL Development and Support at Tele2 (2021-11 – 2023-08)
EDW project - Development and Support in Telecommunication industry
- Requirement Analysis for the different work flows.
- Used various transformations like Filter, Expression, Aggregator, Joiner, Update Strategy Router and to create robust mappings in the Informatica.
- Used PDO for different logic in Informatica.
- Worked on the UNIT testing of the code.
- Worked on all the layer of the Architecture
- Worked on Peer review.
- Doing the data load in UAT environment.
- Data validation
- Involved in UNIX scripting activities as well.
- Resolve the performance issues in the Informatica mappings.
- Used GitHub CI/CD process
