Data Sql

Summary

*+ years of experience in Data Warehousing/Integration using ETLTool InformaticaPower Center 9.6.1/8.6.1/7.1.2 across the business areas such as Healthcare and Banking.

Extensive experience in using Informatica Power Center to carry out the Extraction, Transformation and Loading process.

Create clear and concise epics/stories using JIRA as tracking tool.

Extensive experience with ETL/SSIS tool Informatica in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, and scheduling the Workflows and sessions.

Experienced in integration of various data sources like Oracle 11g/10g, MS SQL Server 2012/2008 and Flat Files into staging area.

Being part of various infrastructure upgrade projects like Informatica 8.x/9.1, Oracle 10g/11g.

Slowly Changing Dimensions Management including Type 1, 2, 3, Hybrid Type 3, De-normalization, Cleansing, Conversion, Aggregation, Performance Optimization

Worked on non-relational sources like Flat Files and used secure FTP.

Worked on Oracle PL/SQL programming, Stored Procedures, Creating Triggers and Sequence Generator on the Target Table.

Assisting in the implementation of JIRA, logging epics, stories and assigning tasks.

Expertise in working with various operational sources like Oracle, Teradata, DB2, SQL Server 2005/2008, Flat files, Netezza into a staging area.

Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSAS, SSRS) including MS solutions like MS EXCEL 2007/2010, Microsoft Office

Expert in writing SQL, PL/SQL Stored procedures using Toad.

Experience with Teradata utilities FastLoad, MultiLoad, BTEQ scripting, Fast Export, SQL Assistant,T-PUMP.

Worked on Performance Tuning Informatica Targets, Sources, Mappings and Sessions.

Experience in developing Informatica Reusable components for using them across the projects.

Extensively worked with Informatica Mapping Variables, Mapping Parameters and Parameter Files.

Experienced in UNIX work environment, File Transfers, Job Scheduling and Error Handling..

Hands on experience in resolving the production issues in 24/7 environment.

Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools

Strong Experience in various Extracting, Transforming and Loading ETL/SSIS data flow ETL/SSIS using SSIS.

Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing and Production Environments

Education:

B.Tech in Electrical & Electronics Engineering, Vignan University.

TECHNICAL SKILLS:

Data Warehousing

Informatica Power Center 9.6.1/9.5.1/9.1.0/8.6.1/8.5.1/7.1.2

Data Modeling

Dimensional Data Modeling, ETL/SSIS, EPICS, FACT, and Dimensions Tables, Physical and Logical Data Modeling.

Databases

Oracle 11g,10g/9i/8i, Teradata v14/15, MS SQL Server 2008/2005, DB2, SQL, PL/SQL, SQL*Plus, SQL*Loader, TOAD, Netezza, SQL*plus, Mongo DB, Data Management tool.

Programming

Java, C, C++, XML, HTML, Java Script, JSP, UNIX Shell Scripting, SQL, PL/SQL, Batch Scripting.

Environment

UNIX, Windows XP/Vista, Linux, Windows 2007 Professional

Professional Experience:

Wells Fargo, Charlotte, NC Nov 2016 - Current

ETL/Informatica Developer

Wells Fargo Credit card system is designed to handle balance transfers and credit limit increase programs from various sources like internet, telephone, mail and also third party vendor files and process them in batch mode. Involved in developing code to meet the business requirements for wells Fargo credit card. This project involved extracting data from different sources and loading into Data warehouse. The Data warehouse is an integrated Data Mine that provides feed for extensive reporting. It enables an insight into the financial situation/needs, scope for delivering superior customer service through a banking operation that is cost-effective.

Responsibilities:

Extensively involved in almost all the phases of Project Life Cycle (SDLC) right from Requirements Gathering to Testing and Implementation etc.

Learned the company’s EDW architecture which consists of sources, middleware, staging area, data warehouse, and reporting tools.

Implemented SSIS Package Configuration using XML configuration files and SQL Server configurations.

Implemented Exception Handling Mappings by using Data Quality, data validation by using Informatica Analyst.

Implemented data views and control tools to the ETL packages for efficient data transformation using SSIS.

Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.

Developed user defined financial reports to provide on demand financial data analysis using SSRS.

Proficient in creating Use Cases, Use case diagrams, Workflow Diagrams, Sequence Diagrams, and Class Diagrams.

Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.

Experience with Netezza Database integration with Informatica and load processes with NetezzaBulk load utilities like Netezza Bulk read and write.

Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop. DocumentedEpics, Features andUser Stories and facilitated Story Point discussions to analyze the level of effort on project specifications.

Loaded data into MDM landing table for MDM base loads and Match and Merge.

Designed, developed Informatica Power Center 9.6.1 mappings to extract, transform and load the data into Oracle 11g target tables.

Designed faster to market technical solutions and Lead as Architect by collaborating with interfacing teams to define the POA and PON from the EPICS, in order to finalize release scope.

Extensively worked on Informatica tools like source analyzer, mapping designer, workflow manager, workflow monitor, mapplets, worklets and repository manager.

Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables

Used Debugger in Informatica Power Center Designer to check the errors in mapping.

Created test cases and completed unit, integration and system tests for Data warehouse.

Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.

Involved in Performance tuning for sources, targets, mappings, sessions and server.

Uses Teradata SQL Assistant to develop queries and access data base objects

Develops Teradata BTEQ scripts to populate target tables.

Develops SQL scripts and ad-hoc queries for data verification during Unit Testing phase of the SDLC.

Worked on agile methodology.

Prepared an ETL technical document maintaining the naming standards.

Created deployment groups in one environment for the Workflows, Worklets, Sessions, Mappings, Source Definitions, Target definitions and imported them to other environments.

Environment:Informatica PowerCenter 9.6.1, Informatica Power Exchange 9.6.1, SSIS 2008, SSRS 2008, Netezza,Oracle 11g, PL/SQL, SQL, Flat Files, TOAD, Teradata 14.Unix, SQL Server 2012.

Missouri Farm Bureau Insurance, Farmington, MOMay2015 –Sep 2016

ETL/Informatica Developer

Missouri Farm Bureau Insurance is one of the biggest and oldest insurance providers in USA. The older databases, which consist of HP-All base and older DB2 tables are being replaced by the newer model DB2 database.

Responsibilities:

Used Informatica PowerCenter 9.1.0 to Extract, Transform and Load data into Netezza Data Warehouse from various sources like Oracle and flat files.

Designed and Developed Mappings, sessions, and workflows in Informatica for data migration.

Created Reusable Transformations and Mapplets and used them in various Mappings to reduce the redundant work.

Worked as part of data validation team to make sure all the requirements are covered.

Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic

Lookup and Router transformations for populating target table in efficient manner.

Created database maintenance plans and deleting of history data using SSIS packages.

Deployed SSIS packages and Reports to Production Servers.

Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).

Developed a High-level dashboard using SSRS 2008.

Performed data validation, reconciliation, and error handling in the load process.

Involved in the exception design and reprocessing the rejected rows to the target tables.

Involved in Conversion load and sync process of the jobs.

Involved in locking the claims which were not successfully migrated so that they will not appear

Develop logical and physical data models that capture current state/future state data elements and data

Worked with Data / Data Warehouse Architect on logical and physical model designs.

Involved in Exception handling and reprocessing in Informatica.

Extensive working experience in PostgreSQL.

Extensive experience in Data validation and Data visualization.

Experience in Agile methodologies.

Involved in analyzing user requirements, Coding, preparing testing specs, database designing and User acceptance training.

Documented the test cases and results for future understanding and reference.

Environment:Informatica Power Center 9.1.0, DB2, HP UNIX, Shell Scripting, PostgreSQL, Business Intelligence Studio (SSAS, SSIS, SSRS),Netezza, Flat Files, Toad.

WellPoint Inc, Hopkins, MN Jan 2015 – May 2015

ETL/Informatica Developer

WellPoint is one of the largest health benefits companies in the United States. Through its affiliated health plans, deliver a number of leading health benefit solutions through a broad portfolio of integrated health care plans and related services. It provides a report of the current and future financial situation/needs based on the information received from the Data Warehouse.

Responsibilities:

Worked with end users to understand the Business Requirements, Designing the Workflow, Implementing and Supporting on ongoing basis.

Expert in writing SQL, PL/SQL Stored procedures using Toad. Experience with Teradata utilities FastLoad, MultiLoad, BTEQ scripting, Fast Export, SQL Assistant,T-PUMP.

Experienced on writing SQL statements and analyzing SQL performance.

Ability to work in teams.

Developed numerous ad-hoc reports using SSRS for day to day financial reporting

Designed data transformation from staging to fact and dimension tables in the warehouse.

Loaded data to the interface tables in oracle from multiple data sources using informatica.

Implemented Aggregator, Filter, Joiner, Expression, Lookup, Normalizer and Update Strategy transformations.

Assisted in upgradation of informatica system from Informatica PowerCenter 8.6 to Informatica PowerCenter 9.1.

Extensively worked on the performance tuning of the Informatica Power Center Mappings as well as the tuning of the sessions.

Implemented variables and parameters in transformations to calculate billing data.

customizing/configuring Business Data director (BDD)/Informatica data director (IDD)applications.

Created sessions, sequential and concurrent batches for the mappings using Workflow Manager.

Writing stored procedures, functions and packages to implement business logic

Worked on different utilities of Teradata like fast load, M-load, T-pump, and Fast export.

Developing, executing & monitoring Autosys (Process Scheduler) jobs.

Wrote services to store and retrieve user data from the MongoDB for the application on devices.

Environment:Informatica PowerCenter 9.1, Flat Files, Autosys, HP ALM (Application Lifecycle Management), Win SCP, Teradata v13, MongoDB.

Inautix, India Sep 2011 to Dec 2014

ETL/Informatica Developer

Data Management team is initiated to build the Central Data Store for the business intelligence reporting. The objective of this project is to integrate the tax professional details, training details, tax return filing details and external data that sent by various franchises and company stores in to central data repository and make available for reporting

Responsibilities:

Analyzed functional specification documents and worked closely with the various application teams and functional teams to design Technical specification documents.

Studied the data requirements and the impact analysis on the existing schema.

Participated in the review meetings with functional team to signoff the Technical design document.

Written Unix Shell Scripts to schedule the informatica jobs using PMCMD command.

Created various active and passive transformations to support voluminous loading of data target table using Informatica PowerCenter.

Designed reusable transformations and mapplets.

Mapped the source and target databases by studying the specifications and analyzing the required Business logic.

Responsible for optimizing the ETL mappings and monitoring the load process in order to check the data.

Involved in identifying surrogate keys for the fact table.

Defined data definitions, and created target tables in the database.

Written PL/SQL Procedures, Function and Packages to perform database operations and pre & post session commands.

Prepared User documentation to train users and functionality of each report.

Environment:Informatica PowerCenter 8.6.0, Oracle 10g, PL/SQL, Toad, UNIX, HP Quality Control, Service Now.

ICICI Ltd, Mumbai, India Nov 2008 to Aug 2011

Role: ETL Developer

Developed an Integrated Banking maintenance System This system consisted of New Depositor, Interest Warrant, Maturity, Premature & Renewal, and Enquire modules. The system was capable of calculating the annual percentage rate, interest period, and amount due on maturity date. Banking maintenance system generated fixed deposit receipts, duplicate fixed receipts, interests warrants, duplicate interest warrants, premature withdraw receipts, maturity receipts and monthly statements.

Responsibilities:

Developed ETL procedures that is consistent across all application and systems.

Created Folders using Informatica PowerCenter Repository Manager to store Source, Target, Transformations, Mapplets and Mappings Meta Data Information.

Worked on Informatica tools like Source Analyzer, Target Analyzer, Mapping Designer, Mapplet Designer and Transformation Developer.

Developed and modified complex SQL Queries and Stored Procedures as per business requirements.

Performed tuning of sessions in Target, Source, Mappings and Session areas.

Normalized the tables to minimize redundancy and dependency.

Created Indexes to speed up the queries.

Creating Technical Specifications and Mapping Documents.

Environment: Informatica PowerCenter 7.1.2, Oracle 10g, SQL, Jira, LINUX/UNIX.

Contact this candidate