Adarsh Bachewale

Client: Citizens Bank.

Project: DQ Risk and Finance.

Tools: AWS, PySpark, SQL, Snowflake, Autosys, JIRA.

Summary: Developed and optimized SQL queries and PySpark jobs for ETL workflows, enabling accurate data transformation and loading into Snowflake for risk and finance reporting. Ensured seamless integration across source systems to support analytics and business decision-making.

Key Responsibilities:

• Designed and optimized complex SQL scripts and PySpark ETL jobs to meet evolving business requirements, reducing data processing time by 25%, and improving reporting accuracy for risk and finance workflows.
• Led a 4-member engineering team in Agile sprints, fostering collaboration, mentoring junior developers, and ensuring 100% on-time delivery of project milestones.
• Managed ad hoc data requests and resolved critical production issues under tight SLAs, achieving 99.9% workflow stability, and minimizing downtime for business-critical reporting systems.

Client: Deutsche Telekom.

Project: AIL (Acquisition Layer) & DWH-Kunde

Tools: Informatica PowerCenter, SQL, PySpark, Db2 (Toad), Unix (Putty), SVN, JIRA, Airflow, Python, Perl, MS Excel

Summary: Developed ETL solutions supporting Deutsche Telekom’s Credit Risk Reporting by integrating customer data into DWH-Kunde. Implemented surrogate key generation, SCD logic, and business transformations to ensure accurate and consistent warehouse reporting.

Key Responsibilities:

• Analyzed diverse source data (Oracle, flat files, JSON), and applied ETL transformations for accurate warehouse integration.
• Developed Informatica mappings, workflows, PySpark jobs, and SQL scripts, improving data processing efficiency.
• Contributed to the full SDLC through specification reviews, coding, testing, debugging, and peer code reviews.
• Managed requirements and business change requests, ensuring alignment with evolving client needs.
• Resolved production issues and implemented hot fixes.