Aishwarya Purohit

Software Engineer

Bengaluru, Karnataka, India7 yrs 3 mos experience

Highly Stable

Key Highlights

6+ years of experience in Data Engineering.
Expert in ETL development and optimization.
Proven track record in improving data processing efficiency.

Stackforce AI infers this person is a Data Engineering expert with extensive experience in Banking, Insurance, and Telecommunications.

Contact

Skills

Core Skills

EtlData Engineering

Other Skills

SQLDatastageUnixOraclePostgresDB2PySparkAWS servicesAWS RedshiftData GovernancePL/SQLT-sqlInformaticaNetezzaData Validation

About

* 6+ years of experience in the field of Data Engineering with ETL Development and IBM Datastage Developer. * Gained Experience in Big Data, SQL, PLSQL, Datastage, Unix, python and Pyspark. * Collaborated with a distributed agile team. •* Responsible for the task assigned and committed to complete it. * Experience in Healthcare, Telecom and Banking and Insurance domains Proactive and motivated Senior Data Engineer with an experience of around 6 years in the IT industry in Datastage and Big Data domain. Certified Associate with good knowledge of SQL and Python.

Experience

7 yrs 3 mos

Total Experience

2 yrs 6 mos

Average Tenure

2 yrs 2 mos

Current Experience

Tech mahindra

Senior Software Developer

Mar 2024 – Present · 2 yrs 2 mos · Bangalore Urban, Karnataka, India · Hybrid

Domain: Banking
Developed ETL process by consuming processed data sources from s3 generated by AWS Glue having target as AWS Redshift, which transformed and processed 10+ million of rows daily basis via Datastage.
Collaborated with cross functional teams to implement data governance frameworks (collibra) enhancing data quality and compliances standards.
Built data acquisition via IBM CDC and AWS DMS migrating 10 millions of relational data to target AWS Redshift.
performed and optimised root cause analysis of daily jobs and troubleshoot ETL failures and resolve complex data issues, reducing occurrence of failures by 50%.
Demonstrate knowledge and experience with tables, data mart and database design and implementation for data warehouse and related functions.
Demonstrate an in-depth knowledge of IBM Datastage (v11.7), including but not limited to Designer, Quality Stage, and Director
Tech Stacks: SQL, Datastage, Unix, Oracle, Postgres, DB2, PySpark, AWS services

SQLDatastageUnixOraclePostgresDB2+4

Pwc india

Senior Data Consultant

Jan 2022 – Feb 2024 · 2 yrs 1 mo · Mumbai, Maharashtra, India

Domain: Insurance, Market research
Migrated 100+ ETL jobs from legacy systems to AWS, including data mapping for hundreds of tables across multiple sources into Redshift, and developed optimised DataStage jobs to support reporting and table updates;
achieved a 40% improvement in ETL performance post-migration.
Developed Informatica ETL jobs to support stock data processing, including data mapping, data modelling
diagrams, and thorough documentation of workflows for easier understanding and maintenance.
Worked on transformation and migration of 20+ Oracle PL/SQL procedures of ETL to optimised Redshift postgresql, enabling a 40% improvement in performance. Used to developed PySpark jobs to build data marts that supported API integrations and reporting.
Gained expertise in AWS tools, PostgreSQL procedures, and full/incremental loads.
Demonstrate an in-depth knowledge of IBM DataStage (v11.7), including but not limited to Designer and Director
Tech Stacks: SQL, Datastage, Unix, Oracle, Postgres, PL/SQL, PySpark, AWS services, T-sql, Informatica

SQLDataStageUnixOraclePostgresPL/SQL+6

Infosys

2 roles

Senior System Engineer

Promoted

Nov 2020 – Dec 2021 · 1 yr 1 mo

Domain: Telecommunications, Healthcare
Designed and implemented scalable ETL processes, jobs resulting in a 20% increase in data processing efficiency.
Collaborated with Data Integration Analyst teams to troubleshoot ETL failures and resolve complex data issues,
reducing occurrence of failures by 30%.
Built robust data validation and quality checks which led to 15% better accuracy and consistency in data.
Documented ETL processes and data mappings ensuring seamless knowledge sharing within teams.
Implemented ETL processes for client provided data, increasing data integration speed by 30%.
Resolved complex data-related issues and optimized ETL processes improving turnaround time by 20%.
Tech Stacks: SQL, Datastage, Unix, Oracle, Netezza, DB2