Mourya

IT professional with 9+ years of experience, including Informatica Developer with 5+ years and 4+ years in Technical Support. ETL Developer experienced in building scalable ETL pipelines using Informatica Cloud (IICS/IDMC), with strong skills in SQL, data warehousing, and integrating data from Oracle, Snowflake, AWS S3, and flat files. Basic hands-on knowledge of Generative AI (GenAI), including LLM concepts, prompt engineering, AI-assisted documentation, and Python-based GenAI fundamentals.

Strong in performance tuning, troubleshooting, and delivering high-quality, reliable data solutions.

Data Engineer - YOUNGELEMENT INDIA PRIVATE LIMITED

(2023-05 - 2026-04)

Applied basic Generative AI concepts to support development productivity, including prompt engineering, LLM fundamentals, and technical documentation.

• Understanding technical requirements given in Source to Target mapping document.
• Extraction, Transformation and Loading (ETL) of data by using IICS/IDMC.
• Extracted source data from flat files, Oracle and loaded to Snowflake.
• Developed mappings in IICS Designer to load data from staging environment to warehouse.
• Develop the mappings using needed Transformations in IICS tool according to technical specifications.
• Create IICS Mapping and task flow with the required transformations and tasks as per the business logic.
• Created complex mappings that involved implementation of Business Logic to load data into staging area.
• Implemented mappings like one-to-one, SCD1 and SCD2.
• Used Transformations including Connected & Unconnected Lookups, Router, Sequence Generator, Stored Procedure, Aggregator, Transaction control, Joiner and others Transformations.
• Work On Performance Tuning activity

Data Engineer - Talisman HR Solutions Pvt. Ltd.

(2022-01 - 2022-09)

• Proficient in Oracle SQL with hands-on experience in DDL, DML, and complex Joins for efficient data manipulation and retrieval.
• Developed Informatica mappings to extract, transform, and load data from various source systems to the landing area.
• Performed data type harmonization between source and target systems to ensure seamless data integration and reduce transformation errors.
• Authored SQL queries to support business logic implementation across various development phases.

Data Engineer - TeamLease Services Ltd.

(2019-12 - 2021-12)

• Write business logic and SQL queries based on functional and technical requirements.
• Hands-on practice in Oracle SQL—including DDL, DML, Joins, and basic stored procedures.
• Created Informatica mappings to gather source onto landing area.
• Performed necessary operations to match datatype of source and target.
• Performed landing to staging load with data cleansing.
• Implemented SQL Queries required for business logics in different phases of developer.
• Prepared Unit test cases for the mappings.

Technical Support - TeamLease Services Ltd.

(2015-06 - 2019-11)

• Resolved client issues via remote sessions and ticketing tools.
• Documented knowledge base and escalated high-severity issues.
• Maintained logs, backups, and performed periodic system checks.

Master of Commerce - Pune University