KRITIKA ASTHANA
Summary
- 4 years of experience in analysis, design, development, testing, implementation, and support of Data Integration Solutions using Informatica Intelligent Cloud Services (IICS).
- Skilled in designing and implementing robust cloud integration solutions and ensuring seamless data flow between cloud applications and databases.
- Well-versed in various IICS concepts related to Data Integration, Monitoring, Administration, Deployments, and Scheduling.
- Proficient in translating business needs into technical specifications and actionable solutions throughout the development lifecycle.
- Skilled in writing SQL queries for data extraction and to improve performance and reduce load times, ensuring efficient data management.
- Experience working with cloud-based database solutions such as AWS Redshift and Snowflake.
- Knowledgeable in scripting with Python and Shell for automating and enhancing data transformation processes.
- Effective lead project team, collaborating with stakeholders to deliver projects on time with high standards of quality and compliance.
- Strong troubleshooting skills for resolving complex data integration issues and ensuring robustness and efficiency of data handling.
Overview
4
4
years of professional experience
Work History
ETL Developer
Deloitte USI
10.2020 - Current
- Developed comprehensive ETL solutions using IICS for integrating multiple data sources as per business specifications
- Build, maintained, and tested ETL Mappings, Mapplets, Workflows, Worklets to ensure the smooth and timely movement of data across systems
- Monitored, tuned, and optimized data integration flows to improve performance and reduce latency
- Developed stored procedures and triggers that streamline data processing workflows, reducing manual efforts, and increasing productivity
- Modified the existing ETL to accommodate the upgraded changes and making sure it runs smoothly without affecting the overall process
- Extensively used transformations like router, lookup, source qualifier, joiner, expression, sorter, XML, Update strategy, union, aggregator, normalizer, and sequence generator
- Interacted with clients and stakeholders to gather business requirements and design specifications
- Ensured data quality and robust solutions through data quality testing, unit testing (UT) and system integration testing (SIT)
- Utilized Python and shell scripting in Informatica and automated complex ETL workflows
- Scheduled and monitored data pipelines using fixed schedules or file listeners for timely execution and system stability
- Implemented data quality checks and validation procedures to reducing data errors and improving overall data reliability
- Managed project operations for smooth execution, including coordinating activities and knowledge transfer to new team members.
Education
Bachelor Of Technology - Electronics & Instrumentation
Banasthali Vidyapith
05.2020
Skills
- ETL Framework: Informatica Cloud (IICS)
- AWS Services : AWS S3, AWS Redshift
- Programming Languages: Python, SQL, Shell Scripting
- Datawarehouse: Redshift, Snowflake
- Tools: WinSCP, Putty, Postman, Jira
- Control System & Documentation: Bitbucket, Jira
Awards
- 2023, Outstanding Award / Deloitte USI
- 2022, Applause Award / Deloitte USI
Timeline
ETL Developer
Deloitte USI
10.2020 - Current
Bachelor Of Technology - Electronics & Instrumentation
Banasthali Vidyapith
Similar Profiles
GURUPRASATH KRGURUPRASATH KR
Senior Consultant at Deloitte USI Consulting - Deloitte DigitalSenior Consultant at Deloitte USI Consulting - Deloitte Digital
Akhtar KhanAkhtar Khan
DC Senior Consultant at Deloitte Consulting India Private Limited (Deloitte USI)DC Senior Consultant at Deloitte Consulting India Private Limited (Deloitte USI)
Suchita MalaniSuchita Malani
Senior Consultant at Deloitte, USISenior Consultant at Deloitte, USI
SHRESTH ISHSHRESTH ISH
Advisory Intern at Deloitte USIAdvisory Intern at Deloitte USI
Assaf TomerAssaf Tomer
ETL Developer at Leumi BankETL Developer at Leumi Bank