ETL developer

Malika Mittal

Professional Summary

*.* years of Strong IT experience and leadership experience in DW/BI specifically in the area of analyzing, designing and implementing business technology solutions in ETL/Data warehousing including 3 years of Onsite experience in US working directly with clients and leading ETL teams.

Have strong conceptual and logical ETL designing skills involving data analyzing, data cleansing and validation, requirements gathering, creating data mapping documents, implementing and testing areas.

Experience in Gathering and Analyzing the data, Cleaning the data to remove errors and ensure consistency of data.

Proficient in understanding DW Business processes / requirements and translating them into technical requirements for ETL DW projects

Excellent analytical, high level and low level design creation, and problem solving skills.

Ability to understand business areas and propose solutions that meet customer needs.

Experience and Knowledge in banking and health care domain. Worked with various prestigious banks like CITI bank, SunTrust Bank, BlueShield of America and Bank of the West.

Experience in working with multiple vendors and geographically distributed teams.

Experience in leading ETL teams, guiding them taking the requirement further till build phase and updating management with the updates.

Strong knowledge in Dimensional modeling like Star Schema and Snowflake Schema.

Extensively used ETL methodologies for supporting data extraction, transformations and loading processing using Informatica Power Centre.

Ability to handle multiple tasks, initiative and adaptable. Proactive team player with capability of handling responsibilities independently as well.

Expertise

Extensive experience in designing and developing Data Warehouses/Data Marts with expertise in using Data Warehousing tools such as Informatica Power Centre and Ab Initio.

Experience in Data Analysis, ETL Design, Development, Testing, Implementation and troubleshooting in the field of Data warehousing and Business Intelligence.

Analyzed the requirements and planned the strategy and approach in driving the development phase of the project.

Been responsible for deployment of ETL mappings after successful completion of testing phase.

Been responsible for defining processes, improving data scalability, and review of designs, codes and test plans.

Been involved in creating technical design documents, build, unit & integration testing, leading ETL team and onsite-offshore co-ordination.

Coordinate with multiple vendors from geographically distributed teams for a successful development, testing and deployment of a single project

Strong database skills, Software Development Life Cycle and development knowledge.

Conduct Impact Analysis, create Design Specifications as per the high-level design, and create Unit Test Plans in order to develop / validate / maintain the application as per the requirements.

Worked on complex SQL Queries, stored procedures, PL SQL.

Proficient in Unix shell scripting.

Hands on experience on EME environment and tracking of Ab-Initio jobs on the same.

Key Domain and Technical Skills

Domain : Banking, Capital Marketing, Health Care

Technical : ETL (Informatica Power Centre, Ab Inito), EXPRESS>IT, BRE, UNIX,

Oracle, SQL Server 2008, DB2, Autosys, CA7, Tidal

Academic Qualification

Bachelor of Engineering in Electrical and Electronics (Honors) in 2010 from Punjab University, Chandigarh, India.

Certifications / Professional Awards:

Foundation course in Banking Domain

Foundation course in Informatica

Microsoft SQL Server 2008 Certification

Professional Experience

Project: CCAR

Client: Bank Of the West

Duration: November, 2017 till date

Role: ETL Lead Developer

Description: The project involves the development and maintenance of an application comprising of data marts which is used to generate data required by the bank to comply with CCAR submission to the Federal Reserve.

Role and Responsibilities:

Understand the client and project requirements (both functional and non-functional) by studying the existing documentation and assimilating inputs from Business Analysts/SMEs and seeking clarifications, if any, to participate efficiently in the Development and Testing phases of the project

Requirement gathering, data analysis for clear understanding.

Document both HLD and LLD for the respective modules.

Work on complex SQL queries and shell scripting.

Develop code using Informatica as ETL tool as per design specifications.

Create health checks for data validations like column validations, count validations, etc. to ensure data quality.

Creating end to end mapping from source till target tables by analyzing the requirements.

Develop code using knowledge of relevant technology as per design specifications

Perform testing - as per defined processes and guidelines to ensure accurate program output; identify and resolve defects, if any

Participate in code and design reviews for code quality improvements

Conduct Impact Analysis, create Design Specifications as per the high-level design, and create Unit Test Plans in order to develop / validate / maintain the application as per the requirements.

Project: Customer 360

Client: BlueShield of California, SFO

Duration: March, 2017 till October, 2017

Role: ETL Team Lead

Description: The project is part of the B Shield of CA Life & Health Ins. C. to create net-new customer data mart assets that will pull data from multiple books of record that are required to support future-facing strategic business needs and enable business users to consume cleaner, more consistent, and more trust-worthy data.

Role and Responsibilities:

Understand the client and project requirements (both functional and non-functional) by studying the existing documentation and assimilating inputs from Business Analysts/SMEs and seeking clarifications, if any, to participate efficiently in the Development and Testing phases of the project

Requirement gathering, data analysis for clear understanding.

Document both HLD and LLD for the respective modules.

Work on complex SQL queries and shell scripting.

Leading ETL team of 5 members and Coordination between offshore team and Clients at onsite location

Develop code using knowledge of relevant technology as per design specifications

Participate in code and design reviews for code quality improvements

Coordinate with multiple vendors from geographically distributed teams for a successful development, testing and deployment of a single project

Work with Tidal Scheduling team to help then create scheduled jobs.

Created mappings for bankers in order to access data through mobile application.

Restructure complex stored procedures into ETL code

Create technical design documents for Client Review

Worked on design deliverables and test plans

Test requirement changes by building complex queries

Convert various complex procedures into Informatica mappings there forth improving overall performance of the data load

Project: E-Statements and Deposits Data Quality Checks

Client: SunTrust Bank, Atlanta, Georgia

Duration: Jan, 2016 till Feb, 2017

Role: ETL Team Lead

Description: E-Statements project will provide the bank the ability to analyze the customers using paperless statements as compared to paper statements across various channels and account types. This will allow the bank to notify the customers and incentivize them with some credits to convert to paperless statements. This will help bank save billions of dollars per annum.

Deposits Data Quality Checks is a project to create a process within data marts that will be used as a reconciliation tool to capture incomplete records transferred from Source files into DIME and loaded into data marts.

Role and Responsibilities:

Understand the client and project requirements (both functional and non-functional) by studying the existing documentation and assimilating inputs from Business Analysts/SMEs and seeking clarifications, if any, to participate efficiently in the Development and Testing phases of the project

Requirement gathering, data analysis for clear understanding.

Document both HLD and LLD for the respective modules.

Creating end to end mapping from source till target tables by analyzing the requirements.

Coordination between offshore team and Clients at onsite location and leading ETL team of 6 members.

Develop code using knowledge of relevant technology as per design specifications

Perform testing - as per defined processes and guidelines to ensure accurate program output; identify and resolve defects, if any

Participate in code and design reviews for code quality improvements

Coordinate with multiple vendors from geographically distributed teams for a successful development, testing and deployment of a single project

Conduct Impact Analysis, create Design Specifications as per the high-level design, and create Unit Test Plans in order to develop / validate / maintain the application as per the requirements

Creating UNIX scripts for Audit checks at various stages of data load.

Schedule jobs using CA7 such that jobs are executed in production in an automated manner.

Project: Credit Risk Marts

Client: SunTrust Bank, Atlanta, Georgia

Description: The project involves the development and maintenance of an application comprising of data marts which is used to generate data required by the bank to comply with CCAR submission to the Federal Reserve. This is an end-to-end application development project involving requirements elaboration, design, build, testing, implementation and support. The system will be developed in multiple releases using the staged waterfall development methodology.

Duration: Jan, 2014 to Dec, 2015

Role: ETL Team Lead

Role and Responsibilities:

Understand the client and project requirements and converting them to technical requirements by creating end to end mapping document and technical specification documents.

Develop and enhance many mappings as per the business requirement to

transform and load complex, high-volume data to data marts.

Redesign of existing code to improve performance.

Convert complex PL SQL code into Informatica mappings for improving performance.

Perform unit testing and create unit test cases to ensure defect free code.

Coordinate with multiple vendors from geographically distributed teams for a successful development, testing and deployment of a single project.

Participate in code and design reviews for code quality improvements.

Conduct Impact Analysis, create Design Specifications as per the high-level design to develop the application as per the requirements.

Coordination between offshore team and Clients at onsite location.

Project: Project One

Client: CITI Bank

Duration: Nov, 2011 to Dec, 2013

Role: ETL Team Lead

Description: The project involves enhancement, maintenance and support of Project One application for the back end Extraction, Transformation and Loading (ETL) modules. The business Objective of this application is to develop a data warehouse management and client-reporting platform for aggregating and reporting client information. As part of Project One, the bank will receive data and information that would be validated, transformed, corrected and loaded into the application databases. The application aggregates all financial and client information into one central database. Once data is loaded into the database, it is worked upon for reconciliation, data quality checks and aggregation for reporting in the form of monthly statements to be sent to clients, while the financial data is also available on web. Project One uses Ab-Initio, a powerful ETL tool with Oracle, which is proven for its capabilities in areas of scalability, performance, security and user management.

Role and Responsibilities:

Develop code and document artifacts including unit test plans and ensure that the output is as per the given specifications and SLAs

Requirement gathering, data analysis for clear understanding

Reengineering of existing mappings as well as creation of new mappings

Create technical design documents

Develop SQL queries for testing end to end code and create UNIX shell scripts for automation and cleanup jobs.

Error logging, checking and Unit testing of the code

Perform testing activities (Functional, Integration, System, User experience) based on the plans and in line with defined processes

Respond to production issues as per SLA

Respond to the issues assigned, conduct analysis, suggest / implement workarounds, communicate to all the stakeholders and close issues as per the agreed timelines

Project: Global Dashboard (GDB)

Client: CITI Bank

Duration: Jan, 2011 to Oct, 2011

Role: ETL Technology Analyst

Description: MIS dashboard is an application that provides a graphical view of client and product information globally to aid senior business leaders in monitoring and measuring key business metrics on a daily basis.

Role and Responsibilities:

Requirement gathering, data analysis for clear understanding.

Create PL SQL code for various client requirements.

Created mappings for bankers in order to access data through mobile application.

Restructure complex stored procedures into ETL code

Create technical design documents for Client Review

Worked on design deliverables and test plans

Test requirement changes by building complex queries

Convert various complex procedures into Informatica mappings there forth improving overall performance of the data load

Project: COE

Client: Capital Group of Companies

Duration: June, 2010 to Dec, 2010

Role: ETL Technology Analyst

Description: The project was an implementation of extracting, transforming and loading various types of financial data in a database and presenting it in form of statements and reports. Besides maintenance of ab initio graphs it involved data -inconsistency fixes, data analysis and day-to-day failures fixes in the ETL jobs.

Role and Responsibilities:

Involved in Designing, coding, and maintaining the ETL systems based on established standards

Reduced data related issues by removing redundancy of data.

Involved in the continuous enhancements and fixing of issues

Infosys Training in Business Intelligence Stream

Trained in Ab Initio, ACE/BRE, Informatica Power Centre, Data Warehousing, SSIS, SSAS, SSRS, UNIX Shell Scripting, SQL, and other BI tools.

Contact this candidate