SUMMARY

• 7+ years of experience in analysis, design, development, maintenance and testing in IT industry.
• Almost 5+ years as ETL Informatica Developer and 2+ years as ETL Tester. Good exposure on banking and insurance domains.
• Experience in Data Warehouse applications using Informatica, Oracle, DB2, MS SQL server on Windows and UNIX platforms.
• Developed tactical and strategic plans to implement technology solutions and effectively manage client expectations.
• Developed effective working relationships with client team to understand support requirements.
• Experienced to work in Development team, Production support teams in handling critical situations to meet the deadlines for successful completion of the tasks/projects.
• Experienced in Repository Configuration/using Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
• Experience in Data Modeling using Star Schema/Snowflake Schema, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modeling using ERWIN 4.x/3.x
• Experience in Unix shell scripting and automation of jobs.
• Developed shell scripts to fine tune the ETL flow of the Informatica workflows.
• Experience in documenting High Level Design, Low level Design, STM's, Unit test plan, Unit test cases and Deployment documents.
• Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Experienced in integration and transforming of various data sources from Databases like MS Access, Oracle, DB2, SQL Server and formats like flat - files, COBOL files, XML, etc.
• Experienced in using ETL tools like Informatica (Power Center) Designer, Repository Manager, Administration console and Workflow Manager.
• Experience in Oracle and MS SQL Server environments using Triggers, functions, SQL, T-SQL and PL/SQL.
• Experience in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification, Identifying data mismatch and import and export of data using ETL tool.
• Strong skills with SQL/ PL-SQL/T-SQL coding.
• Experience in Quality Assurance and strong knowledge of SDLC and Software Test Life Cycle and highly proficient inSQAmethodologies for Waterfall, Agile.
• Experienced in interacting with Clients, Business Analysts, Developers and UAT Users.
• Able to manage all the stages of software development.
• Good understanding of Java, C, C++, Visual Basics.
• Good understanding of Hadoop (Big Data) concepts: HDFS, MapReduce, Hive, Pig and Hbase.
• Great problem solving and analytical skills.
• Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL, Java, C, C++, Python

Databases: Oracle 11g,Teradata, MS-SQL Server 2012/2008,IBM DB2

Operating Systems: IBM AIX, Windows, Red Hat Linux, WindowsXP/NT/7/10

Test Management: HP ALM, HP Quality Center 9.0, RationalClearquest

Defect Tacking Tools: JIRA, Rational ClearQuest

ETL Tools: Informatica, SSIS

BI Tools: Microstrategy, Business Objects, Cognos, OBIEE

Scheduling Tools: AutoSys, Control-M

Hadoop (Big Data): HDFS, MapReduce, Hive, Pig, Hbase, Sqoop

PROFESSIONAL EXPERIENCE

Confidential - Dearborn, MI

Informatica Developer

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Implemented Teradata Utilities such as FastLoad, MultiLoad & FastExport and Teradata Parallel Transporter connections for loading data to enhance runtime and performance.
• Developed UNIX scripts for handling the execution of workflows and pre validation scripts that checks & releases the Table level locks since the last ETL run before loading the current session.
• Handled scripts for pre validating the source File structures before loading into the Staging by comparing the source file headers against the base lined header
• Involved in writing BTEQ scripts for creating staging tables & inserting test data as per requirement.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed one time scripts to correct them.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.6.1.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Involved in Performance Tuning of mappings in Informatica.
• Good understanding of source to target data mapping and Business rules associated with the ETL processes.

Environment: Informatica 9.6.1, Oracle 11g, SQL server 2012, Teradata, SQL, T-SQL, PL/SQL, Toad, SQL Loader, AutoSys, Control-M, Unix.

Confidential - Charlotte, NC

ETL/ Informatica Developer

Responsibilities:

• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
• Created reusable transformations to load data from operational data source to Data Warehouse and involved in capacity planning and storage of data.
• Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.
• Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Used Unix Shell Scripts to automate pre-session and post-session processes.
• Did performance tuning to improve Data Extraction, Data process and Load time.
• Wrote complex SQL Queries involving multiple tables with joins.

Environment: Informatica 9.1, Oracle 11g, SQL Server, Teradata, SQL, T-SQL, PL/SQL, Toad, SQL Loader, AutoSys, XML, Unix Shell Scripts.

Confidential - Jacksonville, FL

ETL/ Informatica Developer

Responsibilities:

• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Designed Informatica mappings by translating the business requirements.
• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Developed mappings for customers, Investments and Risk analysis.
• Developed reusable Transformations.
• Widely used Informatica client tools -- Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
• Worked with various transformations including router transformation, update strategy, expression transformation, lookup transformation, sequence generator, aggregator transformation and sorter transformation.
• Assisted in adding Physical conceptual data model using Erwin 4.0.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Done extensive bulk loading into the target using Oracle SQL Loader.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Designed, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
• Involved in the process design documentation of the DW Dimensional Upgrades.

  Installed, and Documented the Informatica Power Center setup on multiple environments.

Environment: Informatica Power Center 9.1/8.6 (Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle 9i, TOAD, Erwin, Teradata, DB2, Control-M, PL/SQL, UNIX

Confidential

SQL/ETL/Data Warehouse Tester

Responsibilities:

• Analyzed the Business Requirements Specification Documents and Source to Target Mapping.
• Documents and identified the test requirements.
• Tested the various ETL processes that were developed to fetch data from various feeds coming from Admin System.
• Interacted with business users to analyze the business requirements and system functional specifications and prepared Requirements Traceability Matrix (RTM) documents to map the business requirements with the functional and technical requirements and test scenarios.
• Attended daily Scrum Stand-ups for QA updates and defect status.
• Involved in testing Informatica mappings and running the work flows through UNIX environment/GUI.
• Tested the source data for data completeness and data correctness.
• Tested the PL/SQL package that loaded data into staging from the source database.
• Tested the ETL process that loaded the data into target database after performing all the transformations according to the business requirements.
• Writing complex SQL queries for checking the counts and for validating the data at field level (Oracle, DB2, Teradata).
• Tested the format of the reports according to the specifications provided and also compared the data in the reports with the backend datamart through SQL and also using excel for data comparison.
• Involved in end-to-end testing of the entire process flow starting from the source database to the target datamart to the reports by considering all possible scenarios.

Environment: Informatica, SSIS, Cognos 7.0, Microstrategy, HP Quality center 9.0, Visual Basic 6.0, SQL Server 2000, Oracle, Teradata, SQL, T-SQL, PL-SQL, UNIX and Windows NT