PROFESSIONAL SUMMARY:

• Around 6 years of IT experience in Data Warehousing technology and all phases of Software Development Life Cycle (SDLC) including Business Requirement Analysis, Application designing, Development, Implementations and Testing of Data warehousing and Database business systems for Retail, Banking, Financial and Insurance domains.
• Over four years of experience in designing and development of ETL Methodology using Informatica PowerCenter 9.6.1/9.0.1/8. x and one - year experience working with IBM Infosphere DataStage 11.x.
• 4+ years of experience in working with SQL Server, Netezza, ORACLE 11g/10g, PL/SQL and tuning.
• Over a year of experience in Teradata, Used as Source and target.
• Interacted with end-users and functional analysts to identify and develop Business Requirement Document (BRD) and transform it into technical requirements.
• Worked extensively in design and analysis of Requirements, Development, Testing and Production support.
• Prepared various types of documents like requirements gathering, ETL specification, Data Mapping, Test cases, Data dictionary etc.
• Worked on various stages like Aggregator, Transformer, ODBC, DB2 stage, Netezza stage, CDC, SCD, Sort, Merge, and Join etc
• Exposure in writing SQL using analytical functions like Ranking Functions, Reporting Aggregate Functions, LAG/LEAD Functions, FIRST/LAST Functions etc.
• Experience in integration of various data sources like IBM DB2, Oracle, SQL Server, Netezza and Flat Files using Active/Passive Stages available in Data Stage Tool
• Performed Unit testing, System testing, Integration testing and users for UAT and prepared test report in different phases of project.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from Multiple Sources.
• Worked on data integration from various source files such as flat files, CSV files, Relational Databases etc. into a common analytical Data Model.
• Designed and developed complex mappings, Mapplets, tasks and workflows and tuned it.
• Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica.
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets.
• Conducted Unit tests, Integration tests and Customer Acceptance tests (UAT).
• Expertise in OLTP/OLAP Analysis, E-R modeling and dimension modeling.
• Developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Excellent communication skills, ability to communicate effectively with executive and management team, having strong analytical, problem solving skills.

TECHNICAL SKILLS:

ETL TECHNOLOGY: Informatica PowerCenter 9.x/8.x, IBM Infosphere DataStage 11.5

DATA WAREHOUSE: Star Schema, Snowflake schema and Multidimensional Modeling

DATA MODELLING: MS Visio, Erwin 8/7.1

DATABASES: Oracle 11g/10g, MS SQL Server 2012/2005, MySQL, Teradata 14/13, Netezza, DB2.

PROGRAMMING: C, C++, SQL, PL/SQL, HTML, CSS, UNIX Scripting

TOOLS: Quest TOAD, SQL*PLUS, SQL*Loader, SQL*Net, SQL Navigator Export/Import, Oracle Discoverer 10g, Rally and Jira., Control M, Autosys

OPERATING SYSTEMS: Windows 98/NT/2000/XP/7, AIX, Sun Solaris, UNIX and Linux

APPLICATIONS: MS Office, MS Project, FrontPage, Toad 9.2/8.6.

MANAGEMENT TOOLS: MS-Office 2007, MS Project

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

DataStage/ETL Developer

Responsibilities:

• Involved in the Analysis of the functional side of the project by interacting with functional experts to design and write technical specifications.
• Involved in creating detailed technical design documents based on the technical specifications.
• Involved in working with ETL Architects in defining the ETL process.
• Involved in creating ETL design and develop Simple, Medium & complex ETL jobs using DataStage, Netezza and DB2.
• Developed ETL mappings to load into Netezza database tables using COBOL files and flat files as source.
• Experience in using different types of stages like Transformer, Aggregator, Merge, Join, Lookup, and Sort, remove duplicate, Funnel, Filter, Pivot, Shared containers for developing jobs.
• Monitoring the Control - M jobs in on-call rotation
• Deployed the code in Hadoop production environment from development with the help of GitLab and Urban Code Deployment.
• Designed parallel jobs using stages such as Join, Merge, Lookup, Remove Duplicates, Copy, Filter, Funnel, Dataset, Lookup, Pivot, and Sort, Surrogate key Generator, Change Data Capture (CDC), Modify, Row Generator and Aggregator.
• Test and debug the application to ensure compliance with project specification.
• Working with the technical and data architect group to make sure jobs are developed as per the standards used.
• Analyzing the existing production support process, find and fill the gaps and document the same
• Unix scripting for batch process, file validations, monitor scripts
• Prepared the Technical Design Documents and Lower Level Design documents for the technical specs.
• Prepared the Implementation plan for the code migration to QA/Production.

Environment: Data stage 11.5, Hadoop Ecosystem, Hive, Hera Framework, ETL E3 Framework, Control-M, Netezza, Unix

Confidential, Madison, WI

Informatica PowerCenter Developer

Responsibilities:

• Worked with business analyst for requirement gathering, business analysis and testing and project- coordination using interviews, document analysis, business process descriptions, scenarios and workflow analysis.
• Created Technical Design Document or Minor Release Document (MRD) from business requirements document (BRD) or Functional Requirement Document (FRD) business analyst based on business objectives, facilitated joint sessions.
• Analyzed business and system requirements to identify system impacts.
• Created the Detail Technical Design Documents which have the ETL technical specifications for the given functionality, overall process flow for each particular process, Flow diagrams, Mapping spreadsheets, issues, assumptions, configurations, Informatica code details, Database changes, shell scripts etc. and conducted meetings with the business analysis, clients for the Approval of the process.
• Analyzed the existing mapping logic to determine the reusability of the code.
• Handled versioning and dependencies in Informatica.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Translated the PL/SQL logic into Informatica mappings including Database packages, stored procedures and views.
• Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test and supported the UAT for the client.
• Involved in end-to-end system testing, performance testing and data validations.

Environment: Informatica PowerCenter 9.6.1, Oracle 11g, PL/SQL Developer, MySQL, Teradata

Confidential, Oak Brook, IL

Informatica Developer

Responsibilities:

• Gathered report requirements with Business Users and converted them into project documentation.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management. Understand the business needs and implement the same into a functional database design.
• Maintain Development, Test and Production mapping migration Using Repository Manager. Also, used Repository Manager to maintain the metadata, Security and Reporting. Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Populating the business rules using mappings into the target tables.
• Translated the PL/SQL logic into Informatica mappings. Extensively Worked on Database stored procedures and views.
• Used Workflow manager to create and configure workflow and session task to load data. Used Informatica workflow monitor to create, monitor workflow in case of process failures. Performed testing as per UTC.
• Implemented optimization techniques for performance tuning and wrote Pre-and Post-session shell scripts.
• Configured the sessions using workflow manager to have multiple partitions on source data and to improve performance.
• Involved in end-to-end system testing, performance and regression testing and data validations.
• Worked on Data Extraction, Transformations, Loading, Data Conversions and Data Analysis.

Environment: Informatica PowerCenter 9.5/9.1, Teradata 13, Oracle 11g, SQL Server 2012, Erwin 8, Putty, Sun Solaris, Tableau 8, Rally, Basecamp, Winscp, and SCM.

Confidential, Plymouth, MN

Informatica Developer

Responsibilities:

• Designed and developed mappings, Mapplets and sessions from source to target database using Informatica PowerCenter.
• Worked with various file formats like fixed length and delimited.
• Used Debugger extensively to validate the mappings and gain troubleshooting information about data and error conditions.
• Developed various mappings using Mapping Designer and worked with Source qualifier, aggregator, connected unconnected lookups, Filter transformation, and sequence generator transformations.
• Extensively used Informatica to transfer data from different source system and load the data into the target database.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data Warehouse.
• Developed number of complex Informatica mappings, Mapplets and reusable transformations to implement the business logic and load the data incrementally.
• Used Debugger to track the path of the source data and to check the errors in mapping.
• Handled slowly changing dimensions of Type 1 and Type 2 to populate current and historical data to dimensions and fact tables in the Data Warehouse.
• Developed Informatica mappings by usage of aggregator, SQL overrides in lookups, source filter and source qualifier and data flow management into multiple targets using router transformations.
• Document the process for further maintenance and support. Worked on test cases and use cases.

Environment: Informatica PowerCenter 8.6, SQL Server 2008, Oracle 11g, UNIX, Sun Solaris, Jira, Putty, WinSCP, BaseCamp, Erwin 8.5, Toad.