ETL Developer

SUMMARY

Around *+ years of IT experience inclusive of supporting BI applications as a Technology Lead & also support leading application teams and managing ITIL processes.

• Primary strengths include Informatica 9X, SQL server 2008 and Oracle PL/SQL.

• Secondary skills include UNIX Shell scripting and data modeling.

• Good understanding of Database and Data warehousing concepts.

• Strong interpersonal and communication skills.

• Hands on experience in Interacting with SME(s) to resolve application related issues.

• Ability to troubleshoot and having excellent client facing skills.

• Recognized with Project star award Four times in my career.

• Trained new resources on the team with the Data warehousing tools.

• Having the ability to focus on priorities and meet tight deadlines.

• Managed weekly delivery status meeting with client, on-time delivery of change requests as per project plan and ticket resolution SLAs.

TECHNICAL SKILLS

Data Warehousing

Informatica Power Center 8x,9x/Power Exchange 8x, Informatica Developer/IDQ, Datamart, OLAP, OLTP, SQL*Plus.

Databases

Oracle, SQL Server, DB2

Reporting Tools

SQL, PL/SQL, SQL*Plus, Developer 2000, Oracle BI Publisher, Tableau 2018.2

Scheduling Tool

Control M, Oracle DAC

Programming

UNIX Shell Scripting, HTML, XML, SQL, PL/SQL, SQL*Plus

Others

Toad, HP OVSD ticketing tool, WINSCP, Microsoft VSS

Environment

Windows, Unix, MS-DOS 6.22.

PROJECT DETAILS

Infosys Ltd, Bangalore, India Dec’13 to Oct’14

Client: Riverbed Project: Support and Services

Technology Lead

Riverbed is a technology company that specializes in improving the performance of networks and networked applications, with headquarters in San Francisco, California.

This project is focused on delivering the reporting requirements of Services and Support modules in Riverbed. The key objective is to define a data model to cater the reporting needs and design the reports as per business needs. The reports developed helps customers to understand about the metrics related to Knowledge content sharing, Support bookings & revenue details and Renewal attainment rates.

Responsibilities:

●Interacted with business users, reporting analysts in gathering information about the business logic to populate the target tables. Participated in design meetings and perform detail level design.

●Handling production issues and working on developing new design specifications.

●Extensively used Informatica to develop processes for extracting, transforming, integrating and loading data from various sources into Data Warehouse.

●Implemented incremental extraction and incremental load.

●Analyzing the requirement and providing estimation based on the complexity.

●Reviewed and updated technical specification documents for ETL process.

●Documented data sources and transformation rules required to populate and maintain Data Warehouse content. Involved in unit testing, system testing, integration, reporting, and performance testing of the jobs.

●Created source to target mapping and job design documents from staging area to Data Warehouse.

●Attended daily meetings to review the status of the schedule and go through pending issues. Coordinated with Release manager and DA to migrate the components from one environment to another environment.

●Implemented slowly change dimensions (SCD) type 1, type 2, type 3.

Knowledge Transfer for Application Maintenance purpose.

Preparing strategy for implementing the changes and foreseeing the problem.

Interacting with client to resolve application related issues.

Requirement analysis and preparing Design document and Test Case document.

Trouble shooting and problem solving.

Documenting log of resolutions.

Environment: Informatica 9.5, Oracle DAC/BIP, SQL Developer, SQL Loader, Toad, SQL, PL/SQL, Oracle SQL Plus, UNIX Shell Scripting

Capgemini India Pvt Ltd, Bangalore, India Feb’11 to Dec’13

Client: Alcatel-Lucent

Project: Federal Research Tax Credit – DMART

Consultant

Alcatel-Lucent is a global telecommunications equipment company, headquartered in the Paris, France. It provides telecommunications solutions to service providers, enterprises, and governments around the world, enabling these customers to deliver voice, data, and video services.

The RTC Dmart system extracts data from multiple systems (like FDI, GWDW, LKB, TRI, Payroll), validates data quality, transforms data using business rule and loads into Fact and Dimensions table in mart. User uses the BO reporting tool to create the report to analyze the monthly, quarterly and annual tax credits and it integrates two primary types of research customers (Project driven and Cost Center driven users)

Responsibilities:

●Handling production issues and working on developing new design specifications into ETL coding and mapping standards. Implemented incremental extraction and incremental load.

●Created ETL processes composed of multiple ETL jobs using job sequencer and developed shell scripts to automate the process and tested the processes.

●Extensively worked on different databases like Oracle, Db2 and SQL Server to extract and load the data from one another. Performed Peer review for ETL code.

●Used different types of stages like CDC, Remove Duplicate, Aggregator, ODBC, Join, Filter, dataset and Merge for developing different jobs.

●Documented data sources and transformation rules required to populate and maintain Data Warehouse content. Involved in unit testing, system testing, integration, reporting, and performance testing of the jobs. Replaced transformer stages with other stages to improve performance of job.

●Customized UNIX scripts as required for preprocessing steps and to validate input and output data elements.

●Wrote SQL scripts to extract and load data from source and target databases.

●Documented Test Plan, Test Cases, Test Scripts and validations based on design specifications for Unit Testing, prepared test data for testing, error handling and analysis.

●Developed custom routines and transformations for Data Reconciliation of Source.

●Integrated with other Projects, for sharing the table structures and data. Involved in performance tuning by rewriting the queries and modifying existing ETL jobs.

●Involved in production support for production cycle runs and ETL related issues. Communicated data availability with users and management. Documented the purpose of mapping so as to facilitate the personnel to understand the process and incorporate the changes as and when necessary.

●Also involved in ETL test plans, test scripts and validation based on design specifications for unit testing and functional testing.

Environment: Informatica 8.6.1, SQL Developer, SQL Loader, Toad, Control M, SQL, PL/SQL, Oracle SQL Plus, UNIX Shell Scripting, BO

Capgemini India Pvt Ltd, Bangalore, India Oct’09 to Jan’11

Client: WB - Warner Bros.

Project: Sales Data Intelligence

Consultant

WB has decided to decommission the Domestic Theatrical Distribution system (4STAR) and bring the new system in place called TDS (Theatrical Distribution System). This Re-Mapping project is to develop the new mappings and modify the existing mappings to support the existing SDI reporting system.

Responsibilities

Coding as per client standards.

Coding of the assigned modules.

Communicating with client to enable seamless Knowledge Transfer for Application Maintenance purpose.

Preparing strategy for implementing the changes and foreseeing the problem.

Handling Change/Enhancement requests from onsite team.

Interacting with client to resolve application related issues.

Requirement analysis and preparing Test Case document.

Trouble shooting and problem solving.

Documenting log of resolutions.

Environment: Informatica 8.6.1, SQL Developer, SQL Loader, Toad, Control M, SQL, PL/SQL, Oracle SQL Plus, UNIX Shell Scripting, BO

Capgemini India Pvt Ltd, Bangalore, India Jun’08 to Sep’09

Client: TXU Oncor

Project: ODS (Oncor data storage)

Associate Consultant

TXU Oncor is providing Power to its different Retailers for the purpose of power distribution to its customer. And at the same time Oncor is sending them with all the reading information, asset information, billing information to the respective retailers. ODS is the application which is handling all these activities. ODS is like data warehousing as it is managing data from the different retailers, Billing information, asset information etc. TXU is having approximately 75 retailers.

Responsibilities:

Prepare user requirement documentation and Test cases for mapping and additional functionality.

Coding as per client standards.

Coding of the assigned modules.

Preparing strategy for implementing the changes and foreseeing the problem.

Interacting with client twice in a week.

Trouble shooting and problem solving.

Manual testing of developed software routines.

Documenting log of resolutions.

Environment: Informatica 8.6.1, SQL Developer, SQL Loader, Toad, Control M, SQL, PL/SQL, Oracle SQL Plus, UNIX Shell Scripting, BO

EDUCATION

Bachelor of Engineering A.P.S College of Engineering - VTU, Bangalore, Karnataka

CERTIFICATION

1. ITILV3

2. Oracle SQL 10 G

CONTACT DETAILS

Name - Archana Bangalore Yogendra

Ph. - 469-***-****

Contact this candidate