Looking for a job

mangala tripathi

@mangalatripathi

Message

Experienced ETL developer with a strong background in data solutions.

India

Message

What I'm looking for

I am looking for a role that offers opportunities for growth, collaboration, and innovative data solutions.

I am an ETL Developer with over 8 years of progressive experience in architecting, developing, and maintaining robust ETL pipelines and data solutions across both cloud and on-prem environments. My expertise lies in implementing the Software Development Life Cycle (SDLC) to design, develop, test, and deploy effective data engineering solutions. I have successfully led end-to-end data migration projects, transitioning legacy platforms to Informatica PowerCenter and cloud-native ETL solutions while ensuring high data integrity.

My hands-on experience with AWS cloud services, including S3, Redshift, Lambda, and Kinesis, has enabled me to build scalable, automated, and near real-time data pipelines that support analytical workloads. I am proficient in Python for ETL automation and have a strong background in SQL development, performance tuning, and data modeling. I have developed interactive dashboards using Tableau and Power BI, driving business insights and improving stakeholder visibility. I thrive in Agile environments, collaborating closely with business users and QA teams to deliver high-quality data products.

Experience

Work history, roles, and key accomplishments

ETL Developer

Krtrima IQ / Aviana Global

Jan 2019 - Feb 2023 (4 years 1 month)

Migrated complex ETL pipelines from Sagent and Informatica PowerCenter to Informatica IICS, ensuring minimal disruption and complete parity with existing workflows. Re-engineered PowerCenter mappings and workflows for compatibility with cloud-based IICS assets, optimizing performance for scalable execution.

Informatica GitHub Power BI AWS Glue S3 Python NumPy Pandas

Senior Systems Engineer/ ETL Developer

Infosys Limited

Jan 2018 - Dec 2018 (11 months)

Designed and implemented efficient, reusable ETL mappings and workflows using Informatica PowerCenter and SAP BODS to support data transformation and integration needs. Spearheaded a performance enhancement initiative to streamline data extraction and loading processes, achieving a 20% reduction in ETL run time.

Informatica Snowflake Oracle PL SQL SQL Agile Methodologies Data Warehousing

Software Engineer/ ETL Developer

Accenture

Apr 2015 - Jan 2018 (2 years 9 months)

Collaborated with clients to gather functional and technical requirements and provided scalable ETL solutions aligned with business goals. Designed and developed robust ETL mappings in Informatica PowerCenter, extracting data from Oracle-based systems into the Staging layer, Data Warehouse, and Data Marts.

Informatica Oracle Pl SQL Agile Rally Jira