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.
