OBJECTIVE:

Seeking a challenging position in Design, Development, Testing and Implementation of Enterprise Data warehouse systems, using the ETL tools like Informatica PowerCenter/Developer/IICS and Oracle, SQL Server and DB2 databases.

SUMMARY:

• Over Fifteen years of experience in Analysis, Design, Development, Testing and implementation of Relational Database Management Systems.
• Over Fifteen years of experience in Analyze, Designing and Developing the Enterprise Data Warehouse solutions.
• Over Fifteen years of Experience in using Informatica PowerCenter 5.1/6.2/7.2/8.1/8.6/9. x/10 as ETL tool.
• Experienced in using Informatica PowerAnalyzer/Data Analyzer Reporting service.
• Extensive experience in Data modelling for Data Warehouse, Data mart and OLAP for business analysis.
• Experienced in using the Informatica Analyst tool for data profiling.
• Extensive experience in Database applications development using ORACLE 7.X, ORACLE 8/8i/9i/10g/11g, SQL *Plus 2.3/8.0/8.1/9.2/10.2/11. x
• Considerable experience in using Erwin, Visio, to create DFD, ERD, Functional Hierarchy Diagrams and transform to database design.
• Experienced in writing PL/SQL programming units.
• Experienced in User Support and training end users for efficient use of developed applications.
• Good Experience in writing Shell scripts.
• Experienced in supporting the Unix/Oracle/ETL systems in 24X7 environments.
• Familiar with Oracle Architecture and Administration, Net8 etc.
• Experienced in Informatica PowerCenter Installation, setup and Administration.
• Experienced in using the Informatica Analyst Tool.
• Good experience working with Informatica Cloud Services.

PROFESSIONAL EXPERIENCE:

Confidential, Yonkers, NY

Senior Informatica ETL Developer

Responsibilities:

• Analyzing the source data
• Designing the Data warehouse tables
• Designing and developing Informatica ETL mappings
• Writing UNIX Shell scripts
• Writing JIL Scripts for Autosys job schedule

Environment: Informatica PowerCenter 9.6, Oracle 12C, SQL Server, EPIC Care, Linux, Autosys.

Confidential, McLean, VA

Senior ETL Developer

Responsibilities:

• Analyzing the data sources and designing the database tables.
• Profiling the data files and Analyzing the data patterns using Analyst Tool.
• Writing technical specification and data mapping documents.
• Designing, Developing and testing the Informatica ETL mappings using the PowerCenter.
• Creating Reusable PowerCenter objects like Mapplets and Sessions.
• Creating Salesforce Data synchronization and replication tasks using the Informatica Cloud Service.
• Writing UNIX Shell scripts for SFTP and file processing and to schedule PowerCenter jobs.
• Writing PL/SQL programming units.
• Scheduling and monitoring Informatica PowerCenter ETL jobs In Production environment.
• Validating the EDW data against source systems and data files.
• Supporting the MicroStrategy, Tableau and other Reporting tool specific data needs.
• Supporting multiple business teams and users.
• Working with Autosys and DBA support teams to monitor the daily data loads and to quickly resolve any ETL job issues in Production.

Environment: Informatica PowerCenter 9.1/10, Informatica Cloud Services, Informatica PowerExchange, Salesforce, Oracle 11g, PL/SQL, SQL Server, Autosys, SOAP, REST API, Linux, Windows Power Shell, SQL Developer, Web Services, JIRA, Confluence, GIT, Agile.

Confidential , NJ

Senior Informatica ETL Developer

Responsibilities:

• Analyzing the data sources from Fidelity and Hewitt to map the data sources.
• Designing the ETL data mappings and writing technical specification documents.
• Developing the Informatica Mappings to Transform and load the data to HR Data warehouse.
• Creating and transmitting the Daily datasets to load Mainframe DB2 tables, to support the legacy applications.
• Writing the PL/SQL programming units, UNIX shell scripts
• Writing Autosys JIL scripts for job scheduling.
• Monitoring the PowerCenter services and ETL jobs in Production.

Environment: Oracle 9i/10g/11g, PL/SQL Informatica PowerCenter 8.1.1/8.6, AIX, Autosys. MVS DB2, TSO, OBIEE, TOAD.

Confidential, NJ

Informatica PowerCenter Administrator/Developer

Responsibilities:

• Analyzing and documenting the PowerCenter upgrade process.
• Performing the sandbox test for the upgrade process.
• Installing and setting up the new PowerCenter 8.1.1 instances for DEV and PROD environments.
• Upgrading the PowerCenter 7.2 to 8.1.1 Repository.
• Applying the Service packs and EBF’s
• Validating the folders and mappings.
• Testing the performance of Informatica server and ETL jobs.
• Maintaining the repository users and groups.
• Monitoring and supporting the ETL jobs.

Environment: Oracle 9i/10g, Informatica PowerCenter 7.2/8.1.1, Linux.

Confidential, NJ

Informatica ETL Developer

Responsibilities:

• Analyzing the source Oracle HRMS tables and designing the data mart.
• Designing the mappings and writing technical specification documents.
• Developing the Informatica Mappings to Transform and load the Oracle HRMS data to HR Data warehouse.
• Working with the MVS mainframe team to bring the historical data from DB2 mainframe system to Oracle Data warehouse.
• Creating the data Feeds for Bi - Weekly and Monthly payroll processing.
• Working with QA team to create, execute test cases and documenting the test results.
• Writing the PL/SQL programming units, UNIX shell scripts
• Writing Autosys JIL scripts for job scheduling.
• Involved Upgrading the Informatica PowerCenter 6.2 server to 8.1.1 server.
• Working with the Informatica technical support to apply the necessary patches to fix the known bugs.
• Managing the PowerCenter Users and Groups.
• Monitoring the PowerCenter services and ETL jobs in Production.

Environment: Oracle 9i/10g/11g, Informatica PowerCenter 8.1.1/8.6, AIX, Autosys. MVS DB2, TSO, Siebel Analytics / OBIEE, DAC, TOAD.

Confidential, NJ

Informatica ETL Consultant

Responsibilities:

• Designing and developing the data mart Schemas and tables.
• Designing and developing the Informatica ETL mappings.
• Scheduling and monitoring Informatica jobs.
• Creating Analytical schemas in Informatica Power Analyzer (A web based analytical reporting tool).
• Supporting the production system and Reporting developers and users.
• Writing UNIX Schell Scripts and PL/SQL Programming Units.

Environment: Oracle 9.2, DB2 UDB, Informatica PowerCenter 7.1, Toad 7.5, AIX.

Confidential, Chicago

Data Warehouse Developer

Responsibilities:

• Analyzing the Requirements and developing the technical specification documents.
• Designing and developing the ETL Informatica mappings, Workflows.
• Scheduling and monitoring the Informatica jobs.
• Testing for data consistency.
• Writing the PL/SQL Programming Units.
• Writing Shell Scripts.

Environment: Oracle 9.2, SCT Banner, Informatica PowerCenter 6.2/7.1, Toad 7.5, Sun Solaris.