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