SUMMARY

• A result - oriented professional with 6 years of experience in Data Warehouse Development in the Banking and Financial Services and Health Care
• Currently associated with Confidential, Toronto as ETL Developer
• Extensive experience in Data Warehousing Methodologies by implementing Informatica 9.x, OWB and proficient with Databases like Teradata and Oracle
• Proficiency in end-to-end ETL Enhancements, Problem Analysis, Root Cause Analysis for data / design / code issues and its resolution with permanent fix, ETL coding and testing
• Involved in Cloud Migration from Informatica to Spark and Teradata to Amazon Redshift
• Effective in interacting with users for requirement gathering; preparing functional specifications and design documents
• Skilled in Software Development Lifecycle (SDLC) right from requirement analysis, documentation (functional specifications, technical design), coding and testing to maintenance of proposed applications
• Pleasing youthful personality with a zest for life, knowledge and sound understanding of technology

AREAS OF EXXPERTISE

• Data Warehousing Lifecycle
• Root Cause Analysis
• ETL Enhancement
• Designing & Coding
• Documentation
• Client Interaction
• Technical Assistance
• Informatica and OWB
• Teradata and Oracle DB
• Control-M Scheduler
• Spark SQL and Redshift

TECHNICAL SKILLS

Operating Systems: UNIX, WINDOWS

Databases: Teradata 14.0, Oracle, Amazon Redshift

Tools: & Utilities: Informatica Power Center 9.x, OWB, SQL, Spark SQL

Secondary Skillset: UNIX Commands, Control-M, Business Objects, Micro Strategy

PROFESSIONAL EXPERIENCE

Confidential

Programmer Analyst

Responsibilities:

• Analysing the requirement and accordingly designing the document to provide a rough estimate based on high level design document; preparing STT document
• Developing Informatica mappings to load data as per ICDW standards
• Preparing extensive Test Cases and performing Unit Testing and imparting support integration testing
• Managing the onsite and offshore delivery hand shake and daily onsite status calls
• Reviewing the ETL Code, DB Scripts, UTC, Technical Design Documents developed by the team
• Participated in project management activity like WSR, Metrics, Clarity Reporting and so on
• Actively participated in the preparation of Technical Design Document and Run Book as well as conduction of migration activity from DEV to QA, QA to UAT and UAT to PROD
• Initiated the process to maintain code review trackers/check lists for each migration
• Member of the team of twenty-two that developed and managed an application which improved productivity Mortgage Banking in JPMC.
• Performed detailed design for Agile Method along with their implementation, documentation and successfully delivered the Project in time.

Confidential

ETL Developer

Environment: Teradata, Informatica 9.6.0, Spark SQL, Amazon Redshift

Responsibilities:

• Analysed the requirement document, design document based on high level design document.
• Developed Informatica mappings to load data as per EDW standards for SALES, INVENTORY and RECEIPTS.
• Involved in the providing business solutions for Banner decoupling inside Hudson Retail business.
• Actively participated in the preparation of Technical design document, Run book etc.
• Resolving Production issues in different applications.
• Extensively involved in migration of Teradata code to AWS environment (Using Spark SQL and Amazon Redshift).

Confidential

ETL Support/BAU Developer

Environment: Oracle, Informatica 9.6.0, Oracle Warehouse Builder

Responsibilities:

• Supported OWB, Informatica mappings to ensure the completion of batch loads within SLA.
• Provided Support for Finance Systems (Sales, Cost and Spend) and resolving Production issues.
• Creating and Resolving Incidents, Tasks in Service Now (SNOW) and working on the same.
• Actively participated in the weekly Support meeting with Business.
• Responsible for onsite-offshore delivery hand shake and daily onsite status calls.
• Implemented Medium to High Level mappings, Changing Dimensions in OWB as part of enhancements.
• Involved in the Migration/Testing of PROD environment from Informatica 9.6 to Informatica 10.

Confidential

ETL Developer

Responsibilities:

• Analysed the requirement document, design document and provided rough effort estimates based on high level design document.
• Prepared STT document.
• Developed Informatica mappings to load data as per ICDW standards.
• Prepared the extensive Test cases and Performed Unit Testing and co-ordinate in integration testing.
• Actively participated in the preparation of Technical design document, Run book etc.
• Actively participated in Migration activity from DEV to QA, QA to UAT and UAT to PROD.
• Responsible for onsite- offshore delivery hand shake and daily onsite status calls.
• Review of the ETL Code, DB Scripts, UTC, Technical Design documents developed by the team.
• Ensured proper peer reviews and initiated the process to maintain code review trackers/check lists for each migration.

Confidential

ETL Developer

Responsibilities:

• Analysed the requirement document, design document based on high level design document.
• Prepared STT document.
• Developed Informatica mappings to load data as per ICDW standards.
• Prepared the extensive Test cases and Performed Unit Testing and co-ordinate in integration testing.
• Actively participated in the preparation of Technical design document, Run book etc.
• Responsible for onsite- offshore delivery hand shake and daily onsite status calls.