SUMMARY:

• Over 8+ years of experience in IT Industry involving in full life cycle development including requirement gathering, analysis, design, development, testing, implementation, maintenance and documentation of Data warehousing models using ETL tools.
• Over 5+ years of experience on Informatica Power center, IDQ, and also as Database developer and 2 year of Ab Initio experience with ETL, Data Mapping, Transformation and Loading from source to target Databases in a complex, high - volume environment.
• Have extensively worked on Informatica IDQ
• Strong Data Warehousing ETL experience of using Informatica PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, and Oracle PL/SQL.
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1 and type2.
• Worked on various types of transformations like Lookup, Update Strategy, Stored Procedure, Joiner, Filter, Aggregator, Rank, Router, Normalizer, Sorter, External Procedure, Sequence Generator, and Source qualifier and SCD Type-2 etc.
• Expertise monitoring workflows, pipeline partitioning, configuring email.
• Expertise in implementing Power center Mappings, Mapplets and Workflows for the different stages of ETL.
• Experienced in UNIX shell scripts to run Informatica workflows and controlling the ETL flow and also used to to automate the batch application.
• Excellent working experience with creating/modifying the Informatica Scripts and also transition of outdated scripts.
• Expertise in Query Analyzing and Performance tuning.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration, user acceptance testing and documentation.
• Vast experience in development of Ab Initio graphs for ETL (Extract, Transform and Load) of various data feeds coming into the system from different source systems and transforming them as per the business rules and finally loading the transformed data into the database tables.
• Good working knowledge on Ab Initio Business rules engine.
• Worked closely with the business analysts and solution architects in finalizing the technical design of new applications for development / enhancements / production fixes.
• Ability to implement solutions with quantitative, analytical, diagnostic, debugging, and problem solving skills in all phases of SDLC.
• Coordinated with offshore team on development and maintenance projects.
• Substantial experience in Financial, Retail service industry business processes.
• Proven track record of delivering optimal problem solving and decision making technical solutions in fast track development environment within timeframe.
• Experience in creating and enhancing administrative, operational and technical policies and procedures, adopting best practice guidelines, standards and procedures.

TECHNICAL SKILLS:

Platform: UNIX, Windows 2008/2003/XP, Sun Solaris, AIX 5.0/6.1, Red Hat Linux 7.3

ETL tool: Informatica Power center 9.x, 8.x, 7.x (Repository Manager, Powercenter Designer, Workflow Manager,IDQ, Workflow Monitor),Informatica Power Exchanger, Ab Initio CO>OP 3.2/3.1/3.0, GDE 3.2/3.1

Databases: MS SQL Server 2005/2008, Oracle 11g (SQL, PL/SQL, Stored Procedures, Functions) 10g/9i, MS-Access 2000/2003, Sybas, Teradata v2r5/v2r6

DB Tools: C, C++, JAVA, HTML, DHTML, XML, PL/SQL, Visual Basic, UNIX Shell Scripting

Web Technologies: J2EE, HTML, CSS, VB Script, Java Script, Wordpress

Data Modeling/Methodology Tools: MSVisio,ERWIN4.x/3.x,Ralph-KimballMethodology,Bill-Inmon Methodology, Star Schema, Snow Flake Schema, Extended Star Schema, Physical And Logical Modeling.

Protocols: FTP, SFTP, HTTP, TCP/IP, HL7, HIPAA, EDI

Programming: C, C++, JAVA, HTML, DHTML, XML, PL/SQL, Visual Basic, UNIX Shell Scripting

Defect Tracking Tool: HP Quality Center, Jira

CRM Tools: Salesforce.com(SFDC),Force.com, Apex Language, Apex Triggers

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, MO

Sr. Informatica Data Integration Developer

Roles & Responsibilities:

• Responsible for solution design specialist and developer for the Informatica platform to leverage various components of Informatica in order to streamline data ingress and egress in a healthcare environment. used many components of the Informatica platform to build out an ingress/egress solution. have solid experience with Informatica, some recent exposure to IDQ. experience with relational databases (preferably NoSQL), RESTful APIs, and SOAP.
• Lead various subject areas in the project by designing Informatica mappings.
• Worked extensively in design, development, testing and deployment of code.
• Involved in the requirements gathering by interviewing business users and responsible to prepare documentation for detail technical design.
• Involved in analysis of functional requirements, created mapping documents, assisted in code debugging and documentation.
• Worked extensively on design, development and testing for different projects.
• Worked extensively in Coding, testing, debugging, documentation and implementation of several releases.
• Involved in Code Review, Design reviews, testing reviews.
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy and Sequence Generator etc.
• Assume ownership and accountability for the assigned deliverables through all phases of the development lifecycle.
• Used various lookups in the graph to enhance the processing of joins.
• Extensive knowledge in test case review, and Implementation and Post Implementation documents.
• Responsible for the Assembly and the Component Test plans and Test plan execution.
• Contributed the team during testing phase up till leading implementation for getting done various change requests, impact analysis for coding changes done
• Responsible for execution of the module (deliverables, coding to standards/architecture, understand/adhere to change, fix defects, and co-ordinate release management (and other) processes.
• Responsible for Defect Analysis and update status of defects using HP Quality Center.
• Satisfy programming requirements for assigned work with minimum supervision within budget and time constraints.
• Implemented phasing and checkpoint approach in ETL process to prevent data loss and to maintain uninterrupted data flow against process failures.
• Created an Event Publish Service to publish the data near to real time even being a batch process.
• Created a fully parameterized Generic component to modify data for testing. This graph can be used to modify all types of files.
• Developed several generic code for application using dynamic dml and xfrs and also worked on all phases of SDLC for several releases.
• Involved in creating the standard process documents for different projects to share among the team.
• Good knowledge in coding and fine tuning SQL scripts, PL/SQL Stored Procedures
• Extensive working knowledge in UNIX and shell scripting.
• Involved in creating the job files and corresponding schedules.

Environment: Informatica Data Quality, Informatica PowerCenter 9.5, B2B, Web Services, Cassandra, No SQL, MS SQL Server, PL/SQL, Shell Scripting, DB2, RESTful APIs, SOAP, Healthcare File Types, Data Ingress & Data Egress, Ab Initio Co >Op 3.2/3.1, GDE 3.2/3.1.

Sr. IDQ Developer

Roles & Responsibilities:

• Worked with business analysts for requirement gathering (BRD), business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Hands on experience on IDQ, involved in setting up framework from scratch.
• Have experience working on two major components (IDQ Analyst & IDQ Developer) and a series of IDQ Options.
• Hands on experience on IDQ workbench for developing global, reusable Data Quality rules & Data Profiling using IDQ Analyst.
• Knowledge of Informatica Powercenter Data Validation Option (DVO).
• Developed mappings for fact and dimension tables using the various transformations to extract data from different source databases Oracle, Db2 UDB, SQL Server and XML Files.
• Extensive working capability in data integration methodology and technology.
• Involved interactively with the business units to understand the requirements and gather the feedback during the design, development and testing of solutions.
• Designed and developed complex ETL mappings by making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Excellent experience in ETL Tools like Informatica and on implementing Slowly Changing Dimensions (SCD).
• Proven track in lifecycle support code analysis, deployment, migration, production implementations.
• Excellent working knowledge against RESTful API by using HTTP requests to GET, POST,PUT,DELETE.
• Worked with Power Center parameter file, which is a list of parameters and variables and their associated values, includes information for multiple services, service processes, workflows, work lets, and sessions in a single parameter file. Good working knowledge on Control-M.
• Effectively worked on Mapping Designer, Workflow Manager, and Workflow Monitor.
• Extensive knowledge on Analyzing the Software Requirement Specifications and Software Development Life Cycle (SDLC) like waterfall and agile methodologies.
• Executed Informatica workflows using PMCMD utility thru UNIX scripts.
• Provided data loading, monitoring, System support and worked on data issues raised by end user during its production support phase.

Environment: Informatica Data Quality(IDQ), Informatica Power Center 9.5, Oracle 10g/11g, UNIX Shell Scripting, TOAD, SQL, Teradata,Autosys (Job Scheduling tool), SQL, PLSQL, Perforce (version Control System), Version 1 (tool for tracking issues/stories in Agile development environment).

ETL Informatica Developer

Roles & Responsibilities:

• Involved in Complete Software Development Lifecycle Experience (SDLC) like waterfall and Agile methodologies from Business Analysis to Development, Testing, Deployment and Documentation.
• Involved in the design, development and implementations of the Enterprise Data Warehouse (EDW) process and Data Mart.
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy and Sequence Generator etc.
• Worked Efficiently with Designer tools including Source Analyzer, Warehouse designer, Mapping.
• Extensively used SQL coding for overriding the generated SQL in staging and also tested the data loaded into the database.
• Created reusable transformations and mapplets to use in multiple mappings.
• Maintaining existing data flow mappings and fixing any defects associated with them as reported by the QC team.
• Experience in Debugging and Performance Tuning of targets, sources, mappings and sessions.
• Handled large volumes of data warehouse database.
• Performing code review, formal testing, optional testing, and specification review using Test Director.
• Implementing performance tuning methods to optimize developed mappings.
• Conducting debugging sessions and fixing invalid mappings.
• Designed and developed UNIX Scripts to automate the tasks.
• Analyzing production support documents and finding the feasible time to run their jobs.

Environment: Informatica Power Center 8.6, Power Exchange, Erwin, Oracle 10G/9i, SQL Tools, Power Connect, PL/SQL, UNIX, TOAD, Windows XP.

Informatica Developer

Roles & Responsibilities:

• Involved in Complete SDLC like waterfall and Agile methodologies from Business Analysis to Development, Testing, Deployment and Documentation.
• Involved in the design, development and implementations of the Enterprise Data Warehouse (EDW) process and Data Mart.
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy and Sequence Generator etc.
• Worked Efficiently with Designer tools including Source Analyzer, Warehouse designer, Mapping
• Created reusable transformations and mapplets to use in multiple mappings.
• Extensively used SQL coding for overriding the generated SQL in staging and also tested the data loaded into the database.
• Maintaining existing data flow mappings and fixing any defects associated with them as reported by the QC team.
• Experience in Debugging and Performance Tuning of targets, sources, mappings and sessions by handling large volumes of data warehouse database.
• Performing code review, formal testing, optional testing, and specification review using Test Director, analyzing production support documents and finding the feasible time to run their jobs.

Environment: Informatica PowerCenter 8.6, Power Exchange, Erwin, Oracle 9i, SQL Tools, Power Connect, PL/SQL, UNIX, TOAD, Windows XP.

Associate ETL Developer

Roles & Responsibilities:

• Created Data stage jobs to extract, transform and load data from various sources like relational databases, flat files, etc. into the target tables.
• Worked extensively on different types of stages like Sequential file, Transformer, Aggregator, Lookup, Join, Merge, Sort etc.
• Used Data Stage Director to execute and monitor the jobs that perform source to target data loads.
• Responsible for preparation of design documents, Unit testing, performance review.
• Made the required changes to the jobs as per the Business and tracked the changes using QC (quality centre).

Environment: IBM DataStage 7.1, AIX 5.1, Oracle 9g, TOAD, SQL*Loader, HPQC