SUMMARY

• 6+ years of experience in various phases of projects in developing, enhancing and maintaining applications in industry verticals like Insurance, Banking and Retail using Informatica PowerCenter.
• 5+ years of experience in using Informatica PowerCenter (9.1/8.6).
• Configuring and maintaining various components of the MDM Hub including the schema, staging and landing tables, configuring base objects, Look ups, Hierarchies, display queries, put queries and query groups.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Involved in INFA Admin repository upgrade Activities and INFA Admin support Activities.
• Proficiency in developing SQL with various relational databases like Oracle, Teradata.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Performed Informatica upgrade from V8.6.1 to 9.0.1 and 9.1.0.
• Creation and maintenance of Informatica users and privileges.
• Experience with dimensional modelling using star schema and snowflake models.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Strong with relational database design concepts.
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

TECHNICAL SKILLS

Data Warehousing: Informatica PowerCenter version 9.1, 9.5.1 and 8.5.

Reporting Tools: OBIEE, Cognos, Business Objects, Qlikview.

Job Monitoring Tools: DAC, Control - M, Informatica Monitor.

Service Support Management Tools: BMC Remedy, Service Now.

IDQ Languages: PL and SQL, T-SQL, C, Java, C++, UNIX Shell Scripts

Databases: Oracle10/11g, SQL Server, Flat file/excel data sources.

RDBMS: SQL, MySQL, PL/SQL developer10.0.3.

Operating Systems: Linux (Ubuntu 12.04, 14.04), Windows (XP, 7, 8, 10). Informatica Level 2, Networking CCNA and Ethical Hacking from Labs and Racks.

Networking Tools: NS-2, Cisco Packet Tracer, Wire Shark.

PROFESSIONAL EXPERIENCE

Confidential, Pennington, NJ

ETL Developer & Administrator

Responsibilities:

• Creating new repositories from scratch, backup and restore.
• Performed Informatica upgrade from 9.0.1 to 9.5.
• Created Groups, roles, privileges and assigned them to each user group.
• Code change migration from Dev to QA and QA to Production
• Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.
• Used Pre session and Post Session to send e-mail to various business users through the Workflow Manager
• Ensure that all support requests are properly approved, documented, and communicated using the MQC tool. Documenting common issues and resolution procedures
• Extensively used Informatica Client tools -PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Extracted data from various heterogeneous sources like Oracle, Flat Files.
• Developed complex mapping using Informatica PowerCenter tool.
• Extracting data from Oracle and Flat file, Excel files and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformation, Update strategy transformations to load data into the target systems.
• Created Sessions, Tasks, Workflows and worklets using Workflow manager.
• Worked with Data modeller in developing STAR Schemas
• Extensively involved in enhancing and managing Unix Shell Scripts.
• Developed workflow dependency in Informatica using Event Wait Task, Command Wait.
• Involved in analysing the existence of the source feed in existing CSDR database.
• Involved in converting the business requirement into technical design document.
• Documenting the macro logic and working closely with Business Analyst to prepare BRD.
• Involved in requirement gathering for procuring new source feeds.
• Involved in setting up SFTP setup with the internal bank management.
• Building Unix scripts in cleaning up the source files.
• Involved in loading all the sample source data using sql loader and scripts.
• Creating Informatica workflows to load the source data into CSDR.
• Involved in creating various Unix script used during ETL load process.
• Handling high volume of day to day informatica workflow migrations.
• Periodically cleaning up informatica repositories.
• Monitoring the daily load and handing over the stats with the QA Team.
• Creating new repositories from scratch, backup and restore
• Review of informatica ETL design documents and working closely with development to ensure correct standards are followed.

Environment: Informatica PowerCenter 9.1.0/9.5, Flat Files, Oracle 11i, Oracle 11, Autosys, Toad, MS Excel-Macro.

Confidential

Informatica ETL/ BI Developer (Systems Engineer)

Responsibilities:

• Development of Business Intelligence and Reporting management system for Confidential Corporation based in Cleveland, Ohio, USA using BI and ETL tools Informatica, Control- M, BI, Qlikview, OBIEE, BMC Remedy and MySQL.
• Created complex mappings, workflows, sessions using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner using Informatica Power Center 9.5.1.
• Participated in the EL code review meeting to build the Informatica workflow, session and mappings according to the Informatica standards.
• Handled and Resolved Incidents, Change Requests of high priority raised in the production on failure of workflow jobs.
• Involved in migration of tasks, mappings, workflows, sessions from Dev to Prod and testing.
• Worked on migration of project from Informatica 8.6 version to Informatica 9.5.1 version.
• Created the Control M and DAC jobs for all the Informatica cloud jobs, Informatica Workflows, Unix Scripts and scheduled it by setting up the job dependencies between all these jobs.
• Worked with power users, third part vendors and IT teams to understand business logic behind each report, and identified all end users.
• Executed jobs on the request of customer for movement of data between source and target tables through Informatica.
• Created, designed and implemented informatica mappings, workflows and sessions for ETL and BI projects.
• Cleansing of million biometric records for Biometric Research Project in University using ETL processes and logics.
• Market Analysis and Reporting for New Business opening in a city using Qlikview.
• ETL/ Business Intelligence Reporting management system for Shop All (Brand Name) stores using Informatica, BI, Qlikview and MySQL.

Environment: Informatica Power Center 8.5, Flat Files, Business Objects, Qlikview, Oracle 11, Autosys, Toad, MS Excel-Macro.

Confidential

Informatica Developer (Systems Engineer)

Responsibilities:

• Involved in Business Requirements analysis and design, prepared and technical design documents.
• Used Erwin for logical and Physical database modeling of the staging tables, worked with the Data Modeler and contributed to the Data Warehouse and Data Mart design and specifications.
• Developed technical design specification to load the data into the data mart tables confirming to the business rules.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable components such as Mapplets, Reusable transformations and sessions etc.
• Involved in loading the data from Source Tables to ODS (Operational Data Source) Tables using Transformation and Cleansing Logic using Informatica.
• Developed complex Informatica mappings to load the data from various sources using different transformations like source qualifier, connected and unconnected look up, update Strategy, expression, aggregator, joiner, filter, normalizer, rank and router
• Developed mapplets and worklets for reusability.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Implemented partitioning and bulk loads for loading large volume of data.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Created Materialized views for summary tables for better query performance.
• Implemented weekly error tracking and correction process using Informatica.
• Developed Documentation for all the routines (Mappings, Sessions and Workflows).
• Creating Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.

Environment: Informatica Power Center 8.6/9.0.1, Oracle 10g, UNIX (AIX), WINSQL, Windows 7, Flat files, MS SQL Server 2008, MS-Access, Autosys, Ultra Edit.