Sumit Routray

Backend Engineer

Hyderabad, Telangana, India10 yrs 4 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Proficient in ETL development and data warehousing.
Strong background in data quality and cleansing practices.
Experienced in optimizing complex data processes.

Stackforce AI infers this person is a Data Engineering professional skilled in ETL and data warehousing within the Information Technology sector.

Contact

Skills

Core Skills

EtlData Warehousing

Other Skills

Data CleansingData Flow DiagramsData MovementData QualityData ValidationETL ProcessesETL ToolsEnglishIBM Tivoli Workload Scheduler (TWS)InformaticaMicrosoft ExcelMicrosoft OfficeMicrosoft PowerPointMicrosoft WordNetezza

About

Experienced ETL Developer with a demonstrated history of working in the information technology and services industry. Skilled in IICS, Snowflake, Azure Synapse,Data Warehousing, Informatica PowerCenter, Control-M, Tivoli Schedulers, Oracle Database, Netezza database,SQL,Unix.

Experience

10 yrs 4 mos

Total Experience

5 yrs 2 mos

Average Tenure

5 yrs 4 mos

Current Experience

Chubb

Senior Data Engineer

Dec 2020 – Present · 5 yrs 4 mos · Hyderabad, Telangana, India

Cognizant

2 roles

Associate

Jul 2018 – Dec 2020 · 2 yrs 5 mos

Develop the task plan and Ensure the ETL code delivered is running, conforms to specifications and design guideline. Contributed in quality assurance walk through of ETL components
Assist in the ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL-related activities.
Analyze and interpret all complex data on all target systems and analyze and provide resolutions to all data issues and coordinate with data analyst to validate all requirements, perform interviews with all users and developers.
Develop and perform tests on all ETL codes for system data and analyze all data and design all data mapping techniques for all data models in systems.
Document all test procedures for systems and processes and coordinate with business analysts and users to resolve all requirement issues and maintain quality for same.

ETLData QualityData CleansingData MovementTechnical Best PracticesData Warehousing

Programmer Analyst

Dec 2015 – Jul 2018 · 2 yrs 7 mos

Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications.
Monitor all business requirements and validate all designs and schedule all ETL processes and prepare documents for all data flow diagrams.
Review of ETL design documents and working closely with Business/Architect team.
Perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.

Root Cause AnalysisData ValidationETL ProcessesData Flow DiagramsETLData Warehousing