PROFESSIONAL SUMMARY:

• 3+ 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.
• 3+ years of experience in using Informatica PowerCenter (9.1/8.6).
• Experience in data warehousing techniques for Data Analysis, Data Profiling, Data Cleansing, Transformation, Consolidation, Integration, Data Import, Data Export using various source (Oracle, MS SQL Server, DB2, Teradata, XML and Flat files) and target.
• Used Informatica PowerCenter as an ETL to extract data from source like MS SQL Server, Flat files, Oracle, DB2 and Teradata and loaded to target.
• 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:  FTP Server, Oracle108/11g, Netezza.

RDBMS:  SQL Server 2008/2005, Toad, SQL, MySQL, PL/SQL developer10.0.3.

Operating Systems:  Linux (Ubuntu 12.04, 14.04), Windows (XP, 7, 8, 10).

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

WORK EXPERIENCE:

Confidential, Old Westbury, NY

ETL Informatica BI Developer

Activities:

• 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

Activities:

• Development of Business Intelligence and Reporting management system for Eaton 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.
• Extensively worked on databases like SQL 2005/2000 and Oracle 9i/10g/11g and experience in writing complex queries and using Oracle analytical functions.
• Scheduled and monitored all maintenance activities of SQL Server 2000/2005 including database consistency check and index defragmentation.
• 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

Activities:

• 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.