PROFESSOINAL SUMMARY:

• Accomplished ETL Developerwithover 8+ years of experience and technical proficiency in building Data warehouses, Data Marts, and Operational Data Stores, Data Integration, and ETL Processes for clients in major industrial sectors like Retail,Banking andLife Science.
• Experience leading offshore teams of moderate sizes and project delivery.
• Data warehousing experience using InformaticaPower Center10/9.6/8.x/7.x, Data marts, OLAP and OLTP.
• Expertise in Requirement Analysis, Design, Coding, and Testing & Implementation of ETL/DWH projects.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor.
• Proficient as Teradata developer and strong expertise in SQL queries, stored procedures, Teradata Macros.
• Experience in all the phases of Data warehouse life cycle involving requirements gathering, data analysis, design, development, validation & testing of Data warehouses using ETL, Data Modelling, & Reporting tools.
• Experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion,Data Quality and Data Integration - -.
• Strong knowledge on Data Warehousing Concepts like Ralph Kimball Methodology and Bill Inmon Methodology.
• Experience in data modelling using Star schema modelling and Snowflake modelling, Fact and Dimension tables, Physical and Logical modelling.
• Proficient in the Integration of various data sources with multiple Relational Databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata14.0and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Good experience with Data Cleansing andData Analysis and necessary Test plans to ensure successful execution of the data loading processes.
• Strong Knowledge in developing complex mappings, from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Stored Procedure transformations, Sorter, Normalizer, Sequence Generator, Router, Filter, Expression, Aggregator, Joiner and Update Strategy in Informatica Power Centre Designer.
• Experience in using Automation Scheduling tools like Autosys and Control-M.
• Maintained high quality implementation standards by creating and maintaining testcasesand taking part in unit testing with the client.
• Involved in designing until deployment of related activities. Performed peer reviews and thus helped in preventing and resolving technical issues.
• Involved in implementing Slowly--Changing Dimensions mainly Type1, Type2 and Type3 methodologies.
• Good hands on experience in writing UNIX shell scripts to process Data Warehouse jobs.
• Expertise in performing various testing activities like Unit Testing, System Integration Testing (SIT) and User Acceptance Testing (UAT).
• Experience in migrating the workflows, sessions and mappings to QA and Production environments using Repository manager.
• Experience with Advanced Excel features including Filtering, Pivot Tables, Macros, VLookup, and Data Models.
• Good experience in working on MS office tools based reporting and visualizations in Tableau.
• Expertise in migrating Dashboards from Excel reports and Business objects to Tableau Dashboards.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Experience with industry Software development methodologies like Waterfall, Agile within the software development life cycle
• Excellent verbal and written communication skills and ability to work effectively and efficiently in teams and individually.

TECHNICAL SKILLS:

ETL Tools: InformaticaPower Center10/9.x/8.x/7.x, Apache NiFi, Data Meer

Databases: Teradata 14.0, Oracle 11g, SQL Server 2008R2, DB2, MySQL.

Reporting Tools: Tableau, Power BI, TIBCO Spot fire

Scheduling Tools: Autosys, Workload Control Centre

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting.

Operating Systems: DOS, WINDOWS 98, 2000, XP, Vista, Win7, Win 8, UNIX

Other Tools: WinSCP, Putty

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

ETL Developer

Responsibilities:

• Interact with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Understand project scope, identify activities, task level estimates, dependencies, and risks
• Design an ETL specification documents for all the projects
• Provide inputs to review, configuration, deployment, hardware/software requirements.
• Review plan and provide feedback on Gaps, timeline and execution feasibility etc.
• Participate in KT sessions conducted by Business Team and provide feedback on requirements.
• Understand requirements, build codes, support testing and fix defects.
• Involve in Testing, Test Plan Preparation and Process Improvement for the ETL developments, testing, debugging, implementation, documentation, user training & production support.
• Involve in the Performance Tuning of Database and Informatica and Improve performance by identifying and rectifying the performance bottle necks.
• Prepared migration document to move the mappings from development to testing and then to production repositories

Environment : Informatica Power Center, SQL Server, Autosys, Unix, Ms Excel, Power BI.

Confidential, Mettawa, IL

Data Analyst / ETL Developer

Responsibilities:

• Analysed existing Data Model and accommodated changes according to the business requirements.
• Worked directly with non-IT business analysts throughout the development cycle, and provided production support for ETL and have ensured that the client expectations were met.
• Involved in understanding client Requirements, Analysis of Functional specification, Technical specification preparation and Review of Technical Specification.
• Designed and developed Staging and Error tables to identify and isolate duplicates and unusable data from source systems.
• Simplified the development and maintenance of ETL by creating Mapplets, Re-usable Transformations to prevent redundancy.
• Created and Configured Workflows, Work lets, and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager
• Created and worked with generic stored procedures for various purposes like truncate data from stage tables, insert a record into the control table, generate parameter files etc.
• Created Conceptual model based on the business process and identified the entities, attributes and relationships and converted the conceptual model to the logical data model
• Involved in identifying bugs and enhancement of existing mappings by analysing the data flow, evaluating transformations.
• Resolved complex technical and functional issues/bugs identified during implementation, testing and post production phases.
• Identified & documented data integration issues and other data quality issues like duplicate data, non-conformed data, and unclean data.
• Involved in creating dashboards, reports and then published on to the Tableau server.

Environment : Informatica Power Center, Teradata, Oracle, Autosys, Unix, Ms Excel, Tableau.

Confidential, Naperville, IL

Data Analyst/Informatica Developer

Responsibilities:

• Involved in defining and documenting architecture, capturing and documenting non-functional and functional requirements and estimating time and resource allocation.
• Performed data quality analysis, gathered information to determine data sources, data targets, data definitions, data relationships, and documented business rules.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Created and worked with generic stored procedures for various purposes like truncate data from stage tables, insert a record into the control table, generate parameter files etc.
• Analysed existing Data Model and accommodated changes according to the business requirements.
• Designed and developed Staging and Error tables to identify and isolate duplicates and unusable data from source systems.
• Simplified the development and maintenance of ETL by creating Mapplets, Re-usable Transformations to prevent redundancy.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager
• Created Conceptual model based on the business process and identified the entities, attributes and relationships and converted the conceptual model to the logical data model
• Resolved complex technical and functional issues/bugs identified during implementation, testing and post production phases.
• Identified & documented data integration issues and other data quality issues like duplicate data, non-conformed data, and unclean data.
• Implemented Mappings to extract the data from various sources Oracle, XML files and load into
• Oracle and Teradata using Teradata utilities like Mload, Tpump, and Fast Export.

Environment : Informatica Power Center, SQL Server, Datameer, Ms Excel, TIBCO Spotfire.

Confidential, Atlanta, GA

Data Analyst/ETL Developer

Responsibilities:

• Involved in Requirement Gathering and Business Analysis and created tech specs for ETL process.
• Developed data Mappings between source systems and warehouse components using Mapping Designer
• Setup folders, groups, users, and permissions and performed Repository administration using Repository Manager.
• Built the Dimension & Facts tables load process and reporting process using Informatica.
• Consolidated sales order data and loaded to aggregate tables for reporting.
• Coordinated with Onsite and Offshore teams.
• Transferred the source code & setup file to outside conversion team for production movement and support.
• Developed various complex Mapplets and Stored procedure to facilitate loading of data on weekly and monthly basis.
• Worked on Various transformations such as Joiner, Filter, Update Strategy, Expression, Router, Lookup, Union, and Aggregator.
• Administered and developed monitoring scripts for Power Center server process and workflow jobs.
• Designed and developed enhanced data models and ETL applications to meet the business requirement.
• Worked closely with DBA and developers during planning, analysing, developing and testing phase of the project.
• Involved in Designing of Data Modelling for the Data warehouse.
• Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.

Environment : Informatica Power Center, SQL Server, Ms Excel, Qlikview, Unix, Autosys.