SUMMARY:

• 5+ years of experience with design, development, support and implementation of Data Mart / Data Warehouse applications using Informatica PowerCenter 9.x /8.x.
• Diversified experience in requirements gathering and analysis, design, development, testing as ETL, DW and Oracle Database Developer.
• Strong experience in implementing manual change data capture and delete detection functionality in data warehouse.
• 2+ years of experience in leading small and medium sized Data warehousing and Business intelligence projects and mentoring junior or associate consultants.
• Experience creating ETL objects (mappings, mapplets, sessions, workflows) and Performance Tuning in Informatica.
• Strong Data cleansing, Data quality, Data archiving and Data/Code Migration experience using Informatica.
• Responsible for error handling, supporting and scheduling ETL (including production support).
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions.
• Expertise in Oracle SQL and PL/SQL (Stored Procedures, Functions, Packages and Triggers) .
• Highly Skilled with the Integration of various data sources like Oracle, DB2, SQL server, Flat Files, Excel, and XML files.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load and different indexes (PI, SI, JI, HI, PPI).
• Proficient in Performance Tuning, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics, Hints and SQL Trace both in Teradata as well as Oracle.
• Good experience in UNIX shell scripts and Job Scheduling.
• Performed data validation, Integration and End - to-End testing.
• Using HP ALM for storing, maintaining the test repository, bug tracking and reporting.
• Experience in preparing documents on Detailed Technical Design, Migration process, Test cases and ETL Run Book.
• Experience in Agile methodology and sprint planning.
• Experience in prioritizing the product backlog, conducting show and tell to stakeholder.

TECHNICAL SKILLS:

ETL & BI Tools: Informatica PowerCenter 8.x/9.x, Informatica Data Quality, ODI 10g/11g

Languages: SQL and PL/SQL, UNIX Shell Scripting

Databases: Oracle 9i/10g/11g, Teradata

DB Tools: Toad, SQL*plus, Oracle SQL Developer, Teradata SQL Assistance

Environment: Window 2000/NT, Unix-AIX, Linux

Other tools: SharePoint, Putty, WinSCP, Jira, HP ALM

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Senior Informatica Consultant

Roles & Responsibilities:

• Participated in sprint planning, story grooming, design discussion and daily scrum.
• Developed various mappings and mapplets to load data from various sources using different transformations like Source Qualifier, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner, and SQL in the mapping.
• Developed mapping parameters and variables to support SQL override.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Extensively used XML generator and XML parser to load data to XML target.
• Designed complex mapping logic to implement SCD1 and SCD2 dimensions and worked on many critical dimensional modelling which helps in structuring and organizing data in uniform manner.
• Used Debugger to test the mappings.
• Ensuring data quality by reviewing logs and repository tables and making sure there are no duplicates, bad data, rejections, empty data in null columns, etc.
• Developed UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica 9.0.1, UNIX, Putty, WinSCP 5.1.4, Oracle SQL Developer, Toad, Control M

Senior Informatica Developer

Roles & Responsibilities:

• Participated in requirements gathering sessions and meetings with business users to analyze gather and document new business requirements for new projects or change requests/enhancements to the existing projects.
• Migrating ETL jobs from one environment to other.
• Checking existing connections and parameter files related to mapping and creating new connections if needed.
• Developed new ETL jobs as per business requirements .
• Created shell scripts for dynamic generation of Parameter Files and controlling the ETL flow.
• Used TIDAL enterprise scheduler for scheduling the Daily, Weekly & Monthly jobs.
• Involved in the creation of new objects (Tables/Views, Indexes, Keys) in Teradata and modified the existing ETL's to point to the appropriate environment.
• Fixing invalid jobs and troubleshoot the technical problems of the database.
• Used EXPLAIN PLAN, Collect Statistics for performance analysis, monitoring and query tuning.
• Used Teradata utilities like BTEQ, FastExport, FastLoad, MultiLoad to export and load data to/from different source systems including flat files.
• Testing mappings in test environment.
• Preparing the test environments, Test results, tracking of bugs.
• Documentation on Migration process, Test cases and ETL Run Book.
• Giving support to Hadoop team for dependent jobs.

Environment: Informatica 9.5.1/8.6.1, UNIX, Putty, WinSCP, Oracle SQL Developer, Teradata SQL Assistance, Tidal Enterprise Scheduler, ALM, Jira

Senior Informatica Developer

Roles & Responsibilities:

• Extensively worked on Informatica IDE/IDQ.
• Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
• Used IDQ to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes.
• Used various transformations like Address validator, parser, joiner, filter, matching to develop the mappings.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.
• Involved in migration of the mappings from IDQ to PowerCenter.
• Developed the mappings, applied rules and transformation logics as per the source and target system requirements.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables and relational connections.

Environment: Informatica 8.5.1, Informatica Data Quality, Oracle 10g, PLSQL Developer, UNIX, Putty, Jira

Software Developer

Roles & Responsibilities:

• Extensively used ETL to load data from Flat Files, Oracle to Oracle 10g.
• Wrote Unix scripts for the business needs.
• Coded Unix Scripts to unzip zipped files to use them as source file for ETL process.
• Involved in Designing of Data Modelling for the Data warehouse.
• Involved in Requirement Gathering and Business Analysis.
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner.
• Setup folders, groups, users, and permissions using Repository Manager.
• Created, launched & scheduled sessions.
• Involved in the Performance Tuning of Database and Informatica. Improved performance by identifying and rectifying the performance bottle necks.
• Write procedure to automate the insert script for inbound process.
• Analysing data & Preparing Audit Report for project.
• Unit testing code in QA and UAT.
• Giving support to support team during outbound process.

Environment: Informatica 8.1.1, ODI 10g, Oracle 9i/10g, PLSQL Developer, Toad, UNIX, Putty, Jira, Control M