PROFESSIONAL SUMMARY:

• Strong experience in Data Warehouse, SDLC phases, ETL design/development, EDW modelling, Architecture, Data automation.
• Expertize with Informatica tools including Informatica Power Center, Informatica DT Studio, Informatica MDM and Informatica TDM.
• Significant exposure and experience in Business Operations and Reporting in various domains such as Banking, Finance, Oil and Gas, Technology, Healthcare.

TECHNICAL SKILLS & EXPERIENCE:

Data Warehousing/ ETL: Informatica Power Center 9.X/8.X/7.X, Informatica MDM, Informatica DT Studio, Informatica IDQAb Initio, OLAP & OLTP data warehousing

Databases & Tools: Oracle (8.x to latest versions 12g/11g), DB2 UDB 8.5, SQL*Server, Teradata, IBM Netezza, IBM Mainframe, Sybase, Explain Plan, SQL*Plus, SQL*Loader, Net8, TOAD, AGILITY workbench, Data Modelling

Scheduling Tools: Autosys, Informatica Workflow Manager, Maestro/Tivoli

Programming Languages: Unix Shell Scripting, SQL, PL/SQL, Perl, Visual Basic

Web Tools: HTML, ASP, JavaScript, .NET

Environment: UNIX, Win XP/NT 4.0

DETAILED EXPERIENCE:

Confidential, Reston, VA

Tech Lead & Senior Informatica Developer

Responsibilities:

• Leading an Agile Team - Understanding business needs, articulate and design into technical requirements. Support analysis, ETL development, testing and deployment.
• Responsible for ETL design and pattern, architecture of EDW, ETL code development, understanding the requirements and generating comprehensive test data scenarios
• Substantial exposure to design and architecture of ETL patterns and defining entity relationships in accordance with data modelling.
• Worked on Automation of ETL code generation and testing using DTF and Cucumber.
• Interact with the Business Users to analyze the Business Requirements, transform them into the technical requirements, and provide ETL design. Reviewed and emphasized on Process Automation to leverage the common code and processes.
• Strong experience working on Oracle Database and IBM Netezza
• Hands on experience on UNIX scripting
• Hands on experience on Informatica tools - Power Center, MDM, DT Studio, TDM
• Reviewed and standardized ETL design patterns and Entity structures in accordance with data model and business requirement.
• Developed required mappings, sessions and workflows using Informatica Power Center 9.6.1. Designed and created complex mappings and used almost all the transformations such as Expression, Source Qualifier, Joiner, Aggregator, Connected and Unconnected Lookup, Update strategy, Sequence Generator, Router and Filter Transformations.
• Substantial exposure to Informatica DT studio and Informatica IDQ.
• Used data masking techniques to accelerate Testing and Automation in testing.
• Develop config files and scripts for pre and post session usage (UNIX environment)
• Primarily used Autosys for scheduling tasks and end-to-end run of every job
• Generate Testing scenarios after discussion with product owners and develop, streamline and automation of test cases (DTF and Cucumber). Review of test data with ‘source’ team and business divisions.
• Developed data models, created source to target mappings and technical specifications for the development of Informatica (ETL) mappings to load data into various EDW target tables and defining ETL standards.
• Participated in Code reviews, test data and test cases reviews.

Confidential, Irving, TX

Senior Consultant - Data Warehouse Architecture and ETL development

Responsibilities:

• Understood and defined Entity Relationships and ETL pattern architecture based on Data Models.
• Developed data models, created source to target mappings and technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Ensured data quality, supporting compliance, regulation, and supported decision-making using B2B Data Exchange and B2B Data Transformation.
• Developed database Schemas - Star schema, Snowflake schema used in relational, dimensional and multidimensional data modeling using ERWIN and XSD, XML SCHEMA DEFINITION.
• Designed and developed ETL code using Informatica Power Center 9.6.1. Extensively worked with Informatica TDM
• Actively involved in baseline version management, Data Migration and Deployment to higher environments.
• Designed and developed OraclePL/SQL Package for initial loading and processing of Derivative Data. Also worked with Teradata and IBM Netezza
• Designed and created complex mappings using SCD Type II involving transformations such as Expression, Source Qualifier, Joiner, Aggregator, Connected and Unconnected Lookup, Update strategy, Sequence Generator, Router and Filter Transformations.
• Involved in Unit Testing, Data Masking and User Acceptance Testing (UAT) to ensure the end-to-end integrity of the environment and ETL code
• Performed Data Quality checks on using TDM. Developed ETL, common configuration files, Unix Script and automated processes to ensure proper system integration
• Extensively worked on Automation of Testing Process. Created a comprehensive script covering all possible scenarios and automated using the Cucumber

Confidential, Denver, CO

Sr. ETL Developer

Responsibilities:

• Reduced development and testing efforts by generating common scripts and codes, standardizing the Automation processes and code base.
• Worked on Data Warehousing and ETL tools for code development - Informatica Power Center, Informatica DT studio
• Extensive exposure to UNIX scripting, TDM, database exposure to Oracle 11g (TOAD), IBM Netezza (AGILITY workbench), mainframe, use of Autosys and Informatica tools for scheduling, use of data masking for testing
• Extracted data from several source systems and dumped into staging tables after performing ETL logic and then used MDM to perform match and merge rules to create golden records for the clients.
• Experienced in Parsing high-level design specs to simple ETL coding and mapping standards. Substantial use of automated processes to reduce the development and testing efforts.
• Created mapping documents and detailed design documents; as a guideline to ETL Coding.
• Developing workflows with Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Proficient in System Study, Data Migration, Data integration, Data profiling, Data Cleansing / Data Scrubbing and Data quality
• Created landing tables, base tables, staging tables according to the data model and number of source systems
• Defined the foreign key relationships among the base objects and defined look ups on the staging tables and packages, query groups and queries/custom queries
• Experience in creation of ETL Mappings and Transformations using Informatica Power Center to move data from multiple sources into target area using complex transformations like Expressions, Routers, Lookups, Source Qualifiers, XML generator, XML Parser, Aggregators, Filters, Joiners
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data
• Performed ETL code reviews and Migration of ETL Objects across repositories.
• Developed UNIX scripts for dynamic generation of parameter files & automation.
• Monitored day to day Loads, Addressed & resolved Production issues in an abrupt & timely manner and provided support for the ETL jobs running in Production in order to meet the SLA's.
• Maintained repositories and performed Admin level tasks such as creating Folders, Users, Connections & assigning proper roles and privileges.

Confidential, Richmond, VA

Sr Informatica Developer

Responsibilities:

• Responsible to meet with business stakeholders and other technical team members to gather and analyze application requirements.
• Responsible for Design database solutions to satisfy application (business and technical) requirements.
• Excellent in designing ETL Automation processes and strategies to extract data from different heterogeneous source systems like oracle database, Netezza, Flat files, SQL Server, DB2, XML, SAP R/3 and other Relational databases.
• Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Data.
• Involved in designing logical and physical database designing using ERWIN tool.
• Developed Unix Scripts for updating the control table
• Created PL/SQL procedures to transform data from staging to Data Warehouse.
• Develop Business Objects in accordance to clients’ needs and requirements and implement Business Objects development and testing.
• Supported Unit and Regression testing.

Confidential, Memphis, TN

DW Informatica Developer

Responsibilities:

• Gathering of user requirements and source system analysis and establishing mappings between source to target attributes.
• Business Analysis and Business Requirements Gathering.
• Source data analysis and design & Documentation.
• Gained significant experience in Oracle, IBM Netezza, and IBM mainframe, PL/SQL and UNIX shell scripting for Informatica pre & post session operations. Used Informatica designer for developing various mappings.
• Designed and developed ETL Mappings using Informatica to extract data from flat files and Oracle, and to load the data into the target database.
• Created different source definitions to extract data from flat files and relational databases.
• Extensively used various transformations like Source Qualifier, Joiner, Aggregation, Update Strategy, lookup, Rank and Filter.
• Coded various complex business rules and complex queries using PL/SQL.
• Analyzed and fine-tuned PL/SQL scripts.
• Extracted data from various sources like Teradataand relational databases (Oracle).
• Created ETL processes to extract data from Mainframe DB2 tables for loading into various oracle staging tables.
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.
• Used predefined shell scripts to run jobs and dataloads.
• Created, updated and maintained ETL technical documentation.

Confidential

ETL Developer

Responsibilities:

• Interacted with business analysts, data architects, application developers to develop a data model.
• Designed the Data models for Data mart. Created Logical and Physical Data models.
• Extensively used ETL to transform data from different source systems and load the data into the Target database.
• Extensively used Source Qualifier, Aggregator, Filter, Expression, Lookup, Update Strategy, Router and Joiner transformation.
• Implemented slowly changing dimensions according to the requirements, Partitioned sessions, modified cache/buffers and tuned transformations for better performance.
• Created Schema objects like Indexes, Views, and Sequences.
• Designed and developed Oracle PL/SQL Procedures.
• Generated reports using Business Objects Report Designer.
• Developed views necessary for structured and ad-hoc reporting.
• Designed testing procedure and test plans. Assisted in Production support