SUMMARY

• 10 years of extensive experience in Analysis, Design, Development, Implementation & maintenance of Informatica ETL, OLTP & Data Warehouse systems, Business Intelligence and Enterprise Application Integration.
• Having strong experience in Informatica IDQ.
• Solid expertise in Data Extraction, Data Migration, Data Transformation and Data Loading using ETL process in Informatica Power Center 9.x and Informatica Data Quality and Informatica Data Analyst tools and expertise skills in reporting using the Business Objects.
• Experience in all the phases of life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Creation of ETL frame work and review of high level design document.
• Report on progress of data conversions and advocate for specific resolution to unique issues in all internal meetings with Implementation personnel,
• Proficient in data modeling for OLTP relational databases and Data warehouse applications using Ralph Kimball and Bill Inman design principles including Facts and dimensions tables, Slowly Changing Dimensions (SCD) and Dimensional Modeling - Star and Snow Flake Schema.
• Strong working knowledge in design and development of ETL (Informatica) Process, Data (Dimensional and Relational) modeling for Data warehouse(EDW) and scheduling Oracle DAC.
• Experience in integration of various data sources like Oracle, Teradata, DB2, Sybase, SQL server, MS Access and non-relational sources like Flat files and XML files into staging area.
• Experience in developing XML/XSD/XSLT as a part of Source XML files for Informatica and also input XML for Web service Call.
• Experience in designing Reusable Transformations in Informatica such as Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer, Web services and security configuration in Informatica server (end-to-end), Power exchange, Power Connect processing and using Workflow Manager to move data from multiple sources into targets.
• Worked on Data Profiling using IDE-Informatica Data Explorer and IDQ-Informatica Data Quality to examine different patterns of source data. Proficient in developing Informatica IDQ transformations like Parser, Classifier, Standardizer and Decision.
• Experience with creating profiles, rules, scorecards for data profiling and quality using IDQ
• Data Cleansing rules for MDM Projects
• Experience in identifying bottlenecks in ETL Processes and Performance tuning of applications using Database Tuning, Partitioning, Index Usage, and Aggregate Tables, Session partitioning, Load strategies, commit intervals and transformation tuning.
• Solid experience with Informatica Power Center Data Validation client for Unit testing ETL mappings and transformations.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Hands on in application development using with Java, Web Forms in JSP using JDBC.
• Hands on Experience in custom based Applications with Delphi in Client- Server Environment.
• Knowledge of Eclipse tool for the development of java projects.
• Strong SQL, PL/SQL, T-SQL programming skills in Oracle 12c/11g/10g, SQL Server 2012/2008/2000 , Teradata 12 and DB2 databases. Proficient in writing Packages, Stored Procedures, Triggers, Views, Indexes and query optimization.
• Expertise in deploying and maintaining Informatica ETL code into Production environment.
• Extensive experience with Teradata SQL Assistant and Teradata Load/Unload utilities like TPUMP, Fast Export, Fast Load, MultiLoad and BTEQ.
• Experience with issue and project management tool JIRA to track defects. Solid experience in project documentation including Technical specifications and Technical Design Documents (TDD).
• Strong trouble-shooting, problem solving, analytical and design skills.
• Possess effective communication, professional attitude, strong work ethic and interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5/9.6/10.0/10.2

Data Quality: IDQ 9.x/9.6.

Programming Languages: Java, Oracle PL-SQL,Java Script.

Management: Agile/Water fall model.

Databases: Oracle 11/10/9i/8, MYSQL, MSSQL server, Teradata, SOQL.

BI Tools: Informatica Scheduler, Oracle DAC.

Scheduler Tools: AutoSYS

Web Dev Technologies: HTML, XML.

Protocols: TCP/IP, HTTP and HTTPS.

Web services: SOAP UI,Webservice Hub(WSH),Tomcat.

Operating Systems: Linux, MacOS, WINDOWS 98/00/NT/XP.

PROFESSIONAL EXPERIENCE

Confidential, AR

Data Integration/Migration

Responsibilities:

• Supervising the whole conversion process for all rehearsals/cycles as Data Migration/Integration
• Involved with the Business analysts in requirements gathering, analysis, testing and project coordination.
• Prepared standard design documents FD, Technical Specification TD, ETL Specifications and Migration documents.
• Designed and reviewed the Interface/Conversion ETL code before move to QA to ensure design standards are met.
• Solved various performance and complex logic related issues with effective and efficient solution in the ETL process (performance tuning) and identified various bottlenecks and critical paths of data transformation in sessions for different Interface.
• Documenting user requirements, translating requirements into system solutions and developing implementation plan and schedule.
• Involved creation of extended dimension modeling tables like snowflake for Cognos.
• Worked on End to End analysis of the EDW to report the questions/clarifications of Adhoc requests with supporting data and findings.
• Designed and Developed Many complex mapping through Informatica.
• Prepared low level design documentation for implementing new data elements to EDW.
• Ensuring that any key fields and business rules relied upon are conveyed clearly and documented as part of the data integrity requirements
• Created high performance Sql scripts to reduce the time taken for producing ongoing Adhoc reports monthly and weekly.
• Thoroughly tested the Sql scripts by validating the data and cross comparing the data across business for adhoc reports.
• Created complex SCD Type 1, Type 2 and Type 3 mappings using Dynamic Lookup, Joiner, Router, Union, Expression transformations.
• Developed complex Mappings using various transformations like expression, lookups, Update strategy, Sequence generator, Java, Rank, Aggregator, SQL, Xml, Stored procedure and Normalizer.

Environment: InformaticaPowerCenter10.2,Unix,DB2,IBMCURAM,Autosys(CA Work load),Cognos.Secure CRT,JIRA.

Confidential, Philadelphia, PA

Sr Informatica/IDQ Developer

Responsibilities:

• Gathered requirements from Orachestra Network Team(EBX) Application and created ETL Mapping Specification Documentation.
• Involved in the ETL technical design discussions and created ETL high level technical design document
• Analyzed Salesforce and HRMS(Oracle) data and then extracted into Orachestra Network (EBX5) Application .
• Worked with Informatica Data Quality 9.6 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling.
• Identified and eliminated duplicates in datasets thorough IDQ 9.6 Algorithms of Edit Distance, Jaro Distance, Hammer Distance and Mixed Field matcher, It enables the creation of a single view of customers data.
• Developed IDQ mappings using various transformation like Labler,Standarization,Case Converter, Match and Address validation Transformation for third party vendors (KRONOS,Centarl Site Profile(CSP)).
• Used concept of staged mapping (ODS) in order to load data into Flat File and CSV file and load into Orchestra Network Application (EBX5).
• Created Autosys jobs for Informatica and Orachestra Network Application (EBX5).
• Created Tables, Views, Constrains, Synonyms, Sequences.
• Used the inner join, outer join, cross join while writing the complex SQL Queries.
• Used workflow Monitor to monitor the performance of the Jobs.
• Extensively worked in the performance tuning of the ETL process at mapping and transformation level.
• Responsible to migrate the mappings into UAT and Production environment.
• Reviewing the work and submitting the work to client with sufficient documentation

Environment: InformaticaPowerCenter9.6, Informatica Data Quality IDQ 9.6, Orchestra Network(EBX5), Oracle 11g, Autosys(CA Work load).

Confidential, Chicago, IL

Sr Informatica/IDQ Developer

Responsibilities:

• Involved in the analysis of source to target mapping provided by data analysts and prepared functional and technical design documents
• Involved in System Study and Transferred knowledge to offshore team
• Analyzed Salesforce data and then extracted into Microsoft SQL Server 2012.
• Developed IDQ mappings using various transformation like Labler,Standarization,Case Converter, Match and Address validation Transformation .
• Analyzed Salesforce data and then extracted into Microsoft SQL Server 2012.
• Used concept of staged mapping in order to perform asynchronous Web Services request and response as part of Informatica Mappings using Web Service Hub.
• Worked on Batch Web Service Operation using Web service provider component.
• Worked on Real-time Web Service operation using Web service provider component
• Used Collection objects, ref cursor, and bulk collect, aggregate functions while Writing SQL Queries.
• Used workflow Monitor to monitor the performance of the Jobs.
• Extensively worked in the performance tuning of the ETL process at mapping and transformation level.
• Distribution of work to onsite and offshore team and follow-ups.
• Responsible to migrate the mappings into testing and production environment.
• Reviewing the work and submitting the work to client with sufficient documentation
• Responsible to migrate the mappings into testing and production environment.

Environment: InformaticaPowerCenter9.6, Informatica Data Quality IDQ 9.6, Salesforce.com, MicrosoftCRM, SOQL,SQLServer2012, InformaticaScheduler,Oracle DAC.

Confidential

Informatica Developer

Responsibilities:

• Created mappings for initial load in Power Center Designer using the transformations Expression, Router and Source Qualifier.
• Created complex mappings for full load into target in Power Center Designer.
• Test and Troubleshooting problems with all modules of the system.
• Test and developed programming modifications.
• Developed BTEQ, FastLoad and MultiLoad scripts in Teradata. Wrote UNIX Shell scripts.
• Developed the automated and scheduled load processes using Autosys scheduler.
• Responsible for Unit testing and Integration testing of mappings and workflows. Extensively used Informatica PowerCenter Data Validation tool to unit test the ETL mappings.
• Prepared new program code utilizing prescribed specifications.
• Documented programming problems and resolutions for further references.
• Designed and coded application components in an Agile environment utilizing a test driven development approach.
• Created and maintained project tasks and schedules.

Environment: InformaticaPowerCenter9.5, Files, Teradata 12.0,SQLServer2012, Autosys(CA Workload),Oracle DAC.