Close Close Preview

Your amazing online presence is right this way.

Create your profile
Capture who you are, what you do, and where you're going. All in one place.

Sankha Subhra Rudra

Sankha Subhra Rudra

Software Engineer

Tech Mahindra

Hyderabad Area, India, in

ETL Developer with hands on experience in Ab Initio and Informatica PC. Learning MSBI to add into my technical portfolio.

Message
MENU ☰

Tech Mahindra

Software Engineer

Worked as an Ab Initio ETL Developer and Application Support Engineer to support the ETL (Extract, Transform and Load) operations for the Oracle Data Warehouse for SYF Retail Deposit team. The primary responsibility was troubleshooting production issues, fixing defects in the ETL code as well as coordinating with the ETL Development and Business Enablement teams within group.
Experience working with various Ab Initio components such as Dataset components, FBE, Reformat, Rollup, Scan, Join, Sort, Dedup sorted, Partitioning and de-partitioning components, etc and various Ab Initio parallelism techniques.
Scheduling, executing, monitoring and reviewing Autosys jobs for the Ab Initio graphs.
Identifying issues, root cause analysis and fixing the issue encountered in the production environment under time constraints to meet SLA.
Identifying the optimized method to complete the jobs within stipulated SLA.
Process improvement to reduce the cycle time of the loads, thus helping in meeting SLA.
Client addition changes, code review and EME comparisons, migration of graphs to production box.
Client Interactions, handling critical calls.
Experience in designing, developing, executing and maintaining data extraction, transformation, and loading for multiple corporate Data warehousing and Data mart systems.
Good experience in UNIX shell scripting, SQL and Autosys.
Implementing change requests and developing approach documents for issue resolutions, performance fixes and adhoc client requests.
Worked efficiently with onshore/offshore team members to improve the application to run efficiently and within the SLA.
Mentoring new team members to streamline workforce for efficient team performance.
Ticket resolution through IT service and change management tool.
Working knowledge of Informatica PowerCenter.