We provide IT Staff Augmentation Services!

Senior Informatica Etl Developer Resume

Yonkers, NY

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.

Hire Now