Job Search Status
Open to workDesired start date: 2 weeks notice
Desired Job Title
ETL Developer / Software EngineerWork Type
Full TimeLocation Preference
RemoteHybridLocation: Hyderabad, IndiaBengaluru, KA
Open to relocation: Yes
Open To Work
Vakkalagadda Venkata Sai Tejeswar
Hyderabad
Work Preference
Summary
Dynamic ETL Developer with proven expertise at Tech Mahindra, specializing in Informatica PowerCenter and IICS. Achieved 99%+ pipeline uptime through innovative data integration solutions and automated workflows. Skilled in SQL and adept at problem-solving, I enhance data quality and efficiency while meeting critical SLAs in fast-paced environments.
Overview
1
1
Certificate
5
5
years of professional experience
3
3
Languages
Work History
ETL Developer / Software Engineer
Tech Mahindra
12.2021 - Current
- Led end-to-end SDLC for data integration projects, gathering requirements and deploying user training.
- Architected Informatica PowerCenter workflows to maintain 99%+ pipeline uptime across 12 source systems.
- Engineered incremental load and change data capture, improving ETL throughput by 18%.
- Automated execution of ETL workflows using ASG Zena job scheduler to meet critical SLAs.
- Created reusable transformations and mapplets, enhancing ETL development efficiency by approximately 20%.
- Diagnosed and optimized ETL mappings, elevating data quality scores above 98% through systematic performance tuning.
- Resolved production ETL pipeline failures within two-hour SLA windows, preserving 99% overall uptime.
- Migrated legacy Informatica mappings to IICS Cloud Data Integration, enabling scalable cloud data pipelines.
- Taskflow Orchestration & Scheduling: Designed and automated complex iics process flows and linear taskflows with custom decision steps, error-handling routines, and automated email notifications to guarantee 99%+ job reliability.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Education
B.Tech / B.E. - Computer Science
Anna University
Chennai01-2021
Quote
You will recognize your own path when you come upon it because you will suddenly have all the energy and imagination you will ever need.
Sara Teasdale
Skills
- Informatica PowerCenter and IICS
- ETL techniques
- Data integration
- Pipeline design
- Incremental loading
- Full loading
- Data cleansing
- SQL databases
- SQL scripting proficiency
- Scheduling tools
- SDLC methodologies
- Agile frameworks
- Power BI tools
- Databricks utilization
- SLA management
- Cloud data migration
- Performance tuning
Timeline
ETL Developer / Software Engineer
Tech Mahindra
12.2021 - Current
B.Tech / B.E. - Computer Science
Anna University
Certification
- Google Cloud Certified Associate Cloud Engineer, Google, 11/30/26
- Databricks Certified Data Engineer Associate
- Claude Code 101
Accomplishments
- Reduced ETL dataset refresh times by 30%: through advanced Power BI query optimization and incremental refresh strategies.
- Improved ETL development efficiency by 20%: by creating reusable Informatica mapplets and standardized transformation libraries.
- Maintained 99%+ data pipeline uptime: by proactively resolving production failures and implementing robust error-handling mechanisms.
- Automated job scheduling for ETL workflows using ASG Zena: enabling consistent SLA compliance across critical business data loads.
PROJECT
Project # 1: Customer Analytics Client: Selective Insurance Technical Environment: Informatica 10.4/10.5, IICS, PowerBI, Cognos Project Duration: Dec 2021 to Present Role: ETL Developer
Roles and Responsibilities:
- Participated in all SDLC phases: requirement gathering, design, development, testing, production, user training, and support.
- Designed and developed mappings using Informatica Designer (Source Analyzer, Maplet & Mapping Designer) and needed Transformations per technical specs.
- Created complex mappings to implement Business Logic for staging data loads; developed reusable transformations and mapplets.
- Performed data manipulations using Informatica Transformations: Filter, Expression, Lookup (Connected/Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter, Rank, and Union.
- Ensured coding standards using the Undraleu tool and implemented required changes based on reports.
- Resolved production and non-production failures promptly to meet SLAs.
- Developed and monitored workflows using Task Developer, Worklet Designer, Workflow Designer, and Workflow Monitor.
- Built Power BI Datasets based on user requirements.
- Demonstrated strong analytical, communication, and multitasking skills in both independent and team environments.
- Scheduled jobs via ASG Zena workstation to automate Informatica mapping runs per business requirements.
- Prepared High-Level Design (HLD) and Low-Level Design (LLD) documents.
- Participated in Agile activities including sprint planning and retrospectives.
PROFESSIONAL SUMMARY
- Having 4+ years of experience in ETL/Informatica developer, combined with advanced skills in Power BI for reporting and analytics.
- As an ETL developer I have worked on development of new mappings, Workflow’s and involved in enhancements which includes complete responsibility from development to production.
- Developed standard and reusable mappings using various transformations like expression, Joiner, Source qualifier, router, update, lookup and filter in informatica power centre.
- Experience in extraction, transformation and loading of data directly from different heterogeneous source systems like flat files, Excel, Netezza, Sql Server.
- Experience in writing DDL and DML commands in different tables in SQL server 2014 and 2019.
- Utilized Power BI to develop design and optimize data models to support business intelligence needs.
- Provided Production Support for Power Centre, IICS, Power BI, Cognos jobs.
- Excellent communication, inter-personal skills, analytical skills and strong ability to perform as part of a team.