Headline

Application Development Analyst @Accenture || ETL Informatica Developer || IICS Certified || GCP Certified || SQL || Unix/Linux

About

💻 Domain: ETL / Data Integration Developer with 3 years of IT experience in the Pharmaceutical sector. 📊 Focus: Designing and optimizing end-to-end Data Warehousing pipelines for high-business-criticality applications. 🛠️ Technical Stack ☁️ ETL & Cloud: Advanced implementation using Informatica Cloud (IICS) and PowerCenter. 🐚 Scripting: Automation and process optimization via Shell Scripting. 🗄️ Data Sources: Seamless extraction and loading across RDBMS, Flat Files, and Mainframe systems. ⚙️ Core Capabilities 🔄 Execution: End-to-end ETL architecture from source systems to target warehouses. 🔍 Analysis: Strong track record in defect analysis, troubleshooting, and application enhancements. 🤝 Collaboration: Directly managing client communication to gather requirements and deliver technical solutions. Github Resume link : https://userdipi.github.io/

Location

Pune District

AI stack

gemini

hugging face

ollama

openai

Work experience

Application Development Analyst at Accenture, Sep 2024 - Present · 1 yr 10 mos, Pune City, Maharashtra, India, • Proficient in ETL tools (Informatica PowerCenter, IICS), cloud platforms (GCP), and database management (Teradata, Oracle, SQL Server). Ensured data accuracy and consistency by validating datasets between Teradata and Big Query. • Conducted root cause analyses for recurring issues, implementing optimised solutions that reduced pipeline runtime and increased efficiency by 30 minutes • Have learning experience of on boarding projects from on premise to Google cloud platform and ETL upgrades to Informatica Cloud (ICS) from Informatica PowerCenter. • Experience of fixing day to day production failures, reporting and analyzing issues in IICS, GCP platform (L2 development and L2/L3 support role) • Have exposure to GCS bucket, BigQuery, Cloud SQL and Cloud Spanner. • Have played a role of interacting with Business/client as part of EDW Offshore team member and gained experience of understanding key business requirements. • Have worked on Data analysis of Critical tables in Production environment. • Have experience on working on Change management & ticketing tool - BMC Remedy, Servicenow, Atlassian - JIRA stories. • Created Linux based automation scripts to reduce manual effort in day-today tasks and automated email notifications reporting for business. • Worked with business stakeholders to perform multiple data and performance checks on upgraded IICS cloud projects.

Application Development Associate at Accenture, Jul 2023 - Sep 2024 · 1 yr 3 mos, Karnataka, India

Database Analyst at Oda Class, May 2023 - Jun 2023 · 2 mos, Bengaluru, Karnataka, India

Data Analyst at Simplilearn, Mar 2023 - May 2023 · 3 mos, Bangalore

Full Stack Java Development at Tata Elxsi, Sep 2022 - Mar 2023 · 7 mos, India

Jr. R&D Engineer at Glocal Healthcare, Feb 2022 - Jul 2022 · 6 mos, Kolkata, West Bengal, India

Education

Bachelor of Technology - BTech, Computer Science and Engineering, Adamas University

Intermediate, Science (PCMB), D.A.V. Model School, Durgapur