Shivansh Gangwar
@shivanshgangwar
Information System Engineer
Noida, U.P.
Shivansh has over 1 year and 10 months of experience in Information Technology, specializing in ETL, Data Warehousing, and Business Intelligence applications. He possesses hands-on experience in performing Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouses using Informatica Power Center. His expertise includes developing and supporting corporate-wide ETL solutions and ensuring daily support tasks adhere to defined SLAs.
Experience
Software Engineer
Lumen technologies
Informatica Developer/Data engineer
Level3 Communications
Experience in writing SQL statements. Efficiently design Informatica mappings using basic transformations (filters, routers, source qualifiers, lookups) and advanced transformations (Aggregators, Joiner, sorter). Developing Informatica mappings to build business rules and tuning them. Worked on long running jobs and implemented performance tuning solutions to minimize run time at mapping, session, and SQL level.
DWBI Development analyst & Support engineer
Big Data
Experience in Data Warehousing application support for 80+ applications. Extensive experience in ETL using Informatica. Responsible for monitoring jobs and providing L1/L2 support. Application health check daily. Attend to Informatica job failures by analyzing root cause. Automated and scheduled Informatica jobs using crontab scheduler.
Education
Teerthanker Mahaveer University
B.Tech (CS Engineering)
Computer Science Engineering
State board
Intermediate
State board
High School
Licenses & Certifications
Programming with python
Bash Shell Scripting
Oracle PL/SQL