SUMMARY:

• 7+ years of professional experience in Information Technology.
• Deep expertise in Data Integration using Informatica Power Center 9.6.1, IDQ and Talend.
• Extensively worked with Informatica Repository Manager, Power Center Designer, Workflow Manager.
• Extensively used Informatica Transformations such as Expression, Aggregator, Router, Java, Source Qualifier
• Extensively worked on Advanced transformations such as XML, XML Parser, Lookup.
• Extensively worked on Data Quality, Data governance team.
• Conducted source system analysis and data profiling for lifecycle management.
• Experience in scheduling jobs to execute a series of ETL packages.
• Coordinate with various stakeholders such as project lead, business users, Infra structure.
• Participated in Knowledge transfer and support activities.
• Extensively worked with Informatica, IDQ and MDM ETL Tool.
• Working knowledge in conceptual, logical and physical data modeling.
• Experience in Kimball (Bottom - up) InMon (Top-Down) Data Warehouse modeling.
• Databases: Broad working knowledge in Oracle 11g, Teradata v16, SQL Server 2012/2016, HBase.
• Exposure to SOA/API solutions using SOAP, REST, XML.
• Hands on experience with tools such as SQL developer, Toad, SQL Loader.
• Good Knowledge and exposure to Java SE.
• Hands on experience with JIRA UC4, Autosys, Tidal.
• Worked in Agile and Waterfall methodologies.
• Worked on Operating System like Windows 2012 Server, RedHat Linux.
• Knowledge in MDM Services Integration Framework (SIF).

PROFESSIONAL EXPERIENCE:

Confidential,East Lansing, MI

Informatica / IDQ Developer

• Analyzed business requirements to design, develop, and implement highly efficient, highly scalable Informatica ETL processes.
• Worked closely with architects and data analysts to ensure the ETL solution meets business requirements.
• Communicated with key users and conducted JAD sessions with them on various data issues, understood data needs and assisted them with data analysis.
• Involved in Documentation, including source-to-target mappings and business-driven transformation rules.
• Created Tables, Keys (Unique and Primary), Triggers and Indexes in the Oracle server.
• Developed mappings that loaded data from flat-files to the staging tables. Designed the end-to-end data flow in a mapping.
• Used Informatica Power Exchange for loading/retrieving data from mainframe systems
• Created complex Informatica mappings to implement Change Data Capture mechanism by using Type-2 effective date and time logic.
• Used a wide range of transformations such as the Source qualifier, Aggregator, Expression, lookup, Router, Filter, Sequence Generator, Update Strategy and Union Transformations.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Worked on creating PL/SQL, Stored Procedures, Database Triggers, Views, performance tuning and optimization.
• Developed complex Informatica mappings, Mapplets, sessions, worklets and workflows.
• Utilized Informatica Data Quality (IDQ) for data profiling and matching/removing duplicate data, fixing the bad data, fixing NULL values.
• Monitored and cleansed data using Informatica Data Quality (IDQ) - source data profiling using Informatica Analyst and creating mappings in Informatica Developer to apply cleansing and business rules.
• Involved in tuning Informatica Mappings and Sessions as well as tuning at the database level.
• Data warehouse design integration and development of staging, data warehouse scripts and deployment.
• Developed and executed test plans to ensure that the ETL process fulfils data requirements.
• Involved in User Acceptance Testing with end users.

Environment: Informatica Power Center 9.6.1, Informatica IDQ 9.6.1, Oracle 12c/11g, Teradata v16, SQL Server 2012, UNIX, PL/SQL, Toad, Perl scripting, Tivoli Workflow Scheduler (TWS), Business Objects.

Confidential,Auburn Hills,MI

Informatica / IDQ Developer

• Performed the roles of ETL Informatica and IDQ developer on a data warehouse initiative and was responsible for requirements gathering, preparing mapping document, architecting end to end ETL flow, building complex ETL procedures, developing strategy to move existing data feeds into the Data Warehouse (DW) and additional target data warehouses.
• Collaborated with data architects, BI architects and data modelling teams during data modelling sessions.
• Involved in functional design reviews and lead technical design reviews.
• Extensively used Informatica transformations - Source qualifier, expression, joiner, filter, router, update strategy, union, sorter, aggregator and normalizer transformations to extract, transform and load the data from different sources into Teradata, Oracle, DB2 and SQL Server targets.
• Extensively used ETL Informatica to integrate data feed from different 3rd party source systems - Claims, billing, payments.
• Extensively used Informatica Data Quality (IDQ) & Informatica Data Explorer (IDE) profiling capabilities to profile various sources, generate score cards, create and validate rules and provided data for business analysts for creating the rules.
• Used Informatica Data Quality transformations to parse individual consumer information from various vendors to identify the true source of policy holder’s origination and assign credits accordingly by performing various activities such as standardization, labelling, parsing, address validation, address suggestion, matching and consolidation to identify redundant and duplicate information and achieve MASTER record.
• Extensively worked on performance tuning of Informatica and IDQ mappings.
• Created reusable components, reusable transformations and Mapplets to be shared among the project team.
• Extensively used Informatica Data Quality transformations - Parser, Standardizer, Match, Association, Consolidation, Merge, Address Validator, Case Converter, and Classifier.
• Extensively used in-built reference data such as - token sets, reference tables and regular expressions and created new set of reference tables to identify the noise data and standardization of input data.
• Extensive experience in integration of Informatica Data Quality (IDQ) with Informatica PowerCenter.
• Created various data quality mappings in Informatica Data Quality tool and imported them into Informatica PowerCenter as mappings, Mapplets.
• Extensively used XML, XSD / schema files as source files, parsed incoming SOAP messages using XML parser transformation, created XML files using XML generator transformation.
• Worked extensively with Oracle external loader - SQL loader - to move the data from flat files into Oracle tables.
• Coordinated with QA team during QA environment build, reviewing test cases, test execution and defect assignments.
• Extensive knowledge on defect tracking tools - TRAC, RMS as version control management tool.
• Assisted in preparing implementation documents for every release, worked on initial loads and data catchup process during implementations and provided on-call support for first few days of execution.
• Built UNIX Linux shell scripts for running Informatica workflows, data cleansing, purge, delete, and data loading and for ELT process.
• Knowledge on Business objects, updated existing universe with the new data objects and classes using universe designer, built joins between new tables, used contexts to avoid loops and Cartesians.
• Created Procedure Document for Implementation procedures for every release for all the UNIX, Informatica Objects and if any catch-up process needed to be done.
• Provided on-call support for the newly implemented components and existing production environments and made sure that the SLA has been met.

Environment: Informatica Power center 9.1/9.5-HotFix 4, IDQ 9.1/9.5.1 Hotfix 2.0, SQL Server 2008, Windows 2012 Server, Oracle 11g, IBM Main Frames, Redhat Linux, SAP BW, UC4 Job Scheduler.

Confidential,Detroit,MI

Java Developer

• Involved in prototyping, proof of concept, design, Interface Implementation, testing and maintenance. Created use case diagrams, sequence diagrams, and preliminary class diagrams for the system using UML/Rational Rose.
• Designed and developed the persistence tier using Hibernate framework.
• Designed and developed front view components using JSP and HTML.
• Developed re-usable utility classes in core Java for validation which are used across all modules.
• Developed UI navigation using Struts MVC architecture.
• Created JSF components for presentation layer.
• Developed Java classes for implementing Business logics using EJB 3.0 (Stateless session, entity, message driven beans).
• Used JNDI to support transparent access to distributed components, directories and services.
• Deployed and tested the application with web server Tomcat, WebSphere.
• Developed Interactive web pages using AJAX and JavaScript.
• Worked on Report Module, generating PDF/ CSV as per template.
• Configured and tested the application with database server Oracle 10g and MySQL 5.0
• Involved in developing various reusable Helper and Utility classes using Core Java, which are being used cross all the modules of the application.
• Helped in database design and tuning. Created stored procedures, Views in the Database

Environment: Java SE 6, Core Java (Multithreading, Collections), JSP, JSTL, Servlets, Struts 1.2, EJB 3.0, XML, HTML, Java Script, AJAX, SOAP, WSDL, UML, JDBC, Shell Scripting, JUnit, log4j, JMS, Apache Tomcat, WebSphere Application Server, Oracle 10g, MS-SQL Server 2005, Windows NT, Unix/Linux.