Post Job Free

Resume

Sign in

Etl Design

Location:
Ottawa, ON, Canada
Posted:
February 07, 2020

Contact this candidate

Resume:

JYOTHSNA MANDHALAPU

E-Mail: adbnwp@r.postjobfree.com

Professional Summary

• Over 7 years and 10 months diverse experience in ETL code construction as per standards and guidelines defined on the basis of Project Specifications.

• Extensive Hands-on experience in Development, testing and deployment using Data Stage 8.5 and higher versions of Datastage /Quality stage

• Have experience in Talend with big data.

• Experience in Unix Shell Scripting and hands-on experience in Unix/Linux.

• Extensive experience in working with databases such as Oracle, PL/SQL, DB2, Teradata, Postgress, SQL Server

• Experience in data warehousing methodologies.

• Experience in scheduling using Autosys or other scheduling methods.

• Experience in various SDLC - Waterfall and Agile methodologies

• Contributed to Agile Sprint Process through JIRA Management System.

• Knowledge of CI tools like Git, Jenkins, Artifactory/Nexus, JIRA.

• Worked in close collaboration with Architects and other cross functional team members in creating design documents, outlining overview, diagrams, technical requirements and solution that best addresses a business need.

• Participate in technical discussions, client meetings and presentation of solutions to the technical team members as well as Business

• Participate in a code review of peers and junior team members and recommend suggestions for improvement where appropriate to ensure high quality product.

• Analysis of Source System Data with the Integrated functional design and Integrated mapping design Process Low Level Design for ETL processes implementation.

• Developing a Suitable Solutions, alternative and Options.

• Preparing Implementation Strategy and Providing the Support for implementation of the Programs. Ensuring Acceptance, installation and deployment.

• Production support for the entire system.

• Trouble shooting implementation / post implementation issues.

• Communicate with Client to update status and attend the daily sprint calls.

• Responsible for developing and maintaining Scheduling jobs to avoid manual intervention. Responsible for developing and maintaining Automation Scripts (Unix Shell Scripts, SQL) Support during the end to end testing and takes full operational responsibility for the applications.

• Responsible for leading the team and providing solutions for complex issues with the developers

• Responsible for onboard/off board/Mentoring/transfer of KT between the associates in order to ensure smoother running of the project

• Responsible for maintaining the Knowledge Database by documenting frequent issues and workarounds for resolution at a first line.

• Responsible for Developing and testing ETL processes to interface data from multiple internal and external systems.

• Developing ETL jobs that satisfy identified data model and business requirements.

• Translating complex business requirements into technical solutions.

• Performed data analysis and data modelling to create functional design documents and source to target mappings.

• Load target databases using complex transformations that come from many source systems.

• Monitor loads/Volume and troubleshoot any issues that arise.

• Meetings with ETL Design and Project Leads to understand business, financial, and operations requirements and systems goals, and identify and resolve systems issues.

• Participating in the design sessions. Collaboration in planning, design, development, and deployment of new functionality, and enhancements.

• Developed test scenarios and perform in-depth unit tests, including end-user reviews.

• Define ETL job sequence and dependencies including error logging and restart processes as well as develop ETL run book.

• Good hold on ETL processes based on BRD (Business Requirements Document).

• Have knowledge in SAS tools

• Have knowledge of the cloud & hybrid on premise design fundamentals.

• Have Knowledge in Reporting and analysis using Tableau.

• Have an experience in MSOffice (Excel, Powerpoint, Word, Access), Visio, ALM, JIRA. Domain Knowledge

Banking and Financial Sector

Retail Sector

Education

Bachelor’s degree, RMD Engineering college, Chennai, India (2005-2009) Status in Canada

Permanent residence

Technical Skills

Worked on DataStage

7.5,8.1,8.5,9.1,11.5,PL/SQL,DB2,Oracle,Unix/Linu

x scripting,Siperian MDM, Autosys, Mainframe,

hadoop basic, hive basics, Talend, Python

scripting,MySQL

Line of Business Banking and Financial Services, Insurance LinkedIn Profile

https://www.linkedin.com/in/jyothsna-mandhalapu-041631151



Contact this candidate