TECHNICAL SKILLS:

Development methodologies: Agile, Scrum

Operating systems: HP - UX, SOLARIS, AIX, Linux, VMS, WINDOWS, Mac OS X

Programming languages: Java (JDBC, Servlets, Stored Procedures ), C, Pro*C, SQL, PL/SQL, (Stored Procedures, Database Triggers), XML, XSLT

Big data: Hadoop, HDFS, HBASE, Hive, Talend for Big Data

RDBMS: ORACLE, Netezza, SQL Server, My SQL, Informix, Access

RDBMS and data warehouse ETL tools: Informatica, Ab Initio, Talend, Business Objects, Oracle Suite (Oracle Forms, Reports, Graphics), Crystal Reports

Web application development tools: JDeveloper, Cold Fusion, HTML, XML, XMLSpy

Case tools: SQL Navigator, TOAD, SQL Station, DB Architect, E/R Studio, Oracle Designer, Silverrun, PowerDesigner, SQLab Vision, Erwin

Change control and configuration management: TFS, CA/HARVEST, CONTINUUS, SCCS, PVCS, VSS, Clear Case, Smart CVS

GUI & load testing tools: Win Runner, Load Runner

Experience:

Confidential

Informatica Expert

Responsibilities:

• Creating ETL procedure for extracting and mapping Informatica XML mapping metadata in order to generate source to target mapping rules for existing mappings.
• Working on migration of ETL procedures from DB2 to Oracle for SIMS project. Platform was Informatica 9.6.1, Oracle 12.1, on Solaris servers. Migrating and unit testing of mappings, mapplets, workflows and parameter files.
• Developing XML parser in Informatica Power Center in order to parse hierarchical XML source files and map it to the target Oracle tables. Artificial target table keys were generated.
• Creating Source to Target mapping document documenting transformation rules from existing mappings.
• Installation and configuration of Master Data Management in order to produce detail documentation of source to target mapping.
• Installation and configuration of Master Data Management in order to produce detail documentation of source to target mapping.
• Senior Consultant with experience in Transactional (OLTP), Master Data Management (MDM), Data Lakes, and Business Intelligence systems (using Kimball Star Schema methods), and microservices using Canonical Data Models.

Confidential

Informatica Expert

Responsibilities:

• Working on Risk Assessment and Reporting project (RAR) which represents the overall process flow of risk assessment and reporting from its inception (the acquisition of data) to its end (dissemination of the reports). Source and target database was Oracle on Solaris platform.
• Developing parsers and data transformation components in Informatica Developer 10.1 in order to parse multiple PDF files from the source, transformed it and write to the target tables.
• Gathered and cleansed data collected from a number of sources using Informatica 10.1 Power Center, developing mappings and workflows.
• Transformed the data and calculated different risk statistics/results.
• Developed scripts for automated import and deployment of Informatica workflows into integration environment. Migrating code from Informatica 9.6 to 10.1.
• Using Informatica Master Data Management in order to produce graphs and matrix of source to target mapping.
• Using Informatica Master Data Management in order to produce graphs and matrix of source to target mapping.
• Provided oversight and direction to Data Quality and MDM initiatives

Confidential

Talend Etl Expert

Responsibilities:

• As part of Retail Credit Risk Reporting program (RCRR) built a Certified Data Store (CDS) on Scotiabank’s Enterprise Data Lake (EDL).
• Acquired and ingested source data into EDL (Hadoop and HDFS platform) to support RCRR interim reporting requirements.
• Developed Talend Big Data Edition data transformations, data validation, standardization, and data integration in EDL (Hive platform).
• Developed data warehouse related functionalities (e.g. surrogate key generation, change data capture, slowly changing dimensions).
• Provisioned data for RCRR consuming applications (CRP, GLRAS, and CPP).

Confidential

Senior Informatica Etl / Netezza Developer

Responsibilities:

• As a member of the core ETL team developing ETL procedures in Informatica Power Center in order to implement Bi-Temporal processing for RDA (Risk Data Aggregation) project.
• Sources were outputs from risk engines stored in Netezza for various feeds, which were imported in Netezza staging tables.
• ETL procedures are implementing appropriate lookups to convert codes and alternative keys into surrogate keys and applying appropriate Bi-Temporal updates to RCRM Netezza database.
• Data is then available for consumption by Composite and Cognos.
• Writing and tuning Netezza stored procedures to implement load to dimension and fact tables. Developed generic stored procedure using dynamic SQL for loading hundreds of dimensional tables.
• Implementing full cycles of Agile Sprints, planning sessions, daily stand-up meetings using Microsoft TFS and Visual Studio for source control.

Confidential

Senior Etl developer

Responsibilities:

• Developing Informatica mappings for loading complex object structures in XML format. Developing XML parser in Informatica Power Center in order to parse hierarchical XML source files and map it to the target Oracle tables.
• Using Oracle analytical functions for fine-tuning SQL procedures for faster execution, replacing function calls with analytical functions.
• Developing and maintaining Rule Management System, metadata application and database used for defining business rules for Enrolment Application.
• Developing complex Oracle PL/SQL packages working with object types for Enrolment System batch application. Creating design documents based on use cases that capture business requirements. Using Hudson/Jenkins environment for change control, build and deployment of new modules. Platform was Oracle 11g, and Solaris. Using Test Driven methodology for development and testing with JUnit framework.
• Worked with top management from TDS, senior IT management from clients and license holders, including executive sponsors, chief architects, and product management group, to determine define TM application functionality, tool selection, database design, data movement strategies, Master Data Management strategy and implementation.

Confidential

Senior Etl Developer

Responsibilities:

• Developing ETL procedures using Talend Open Studio in order to capture and transform users data entered in XML format and populate TimePlay Data Warehouse used for statistical reports. Designing database schema in MySQL used for storing statistical data.
• Developing transfer procedures using shell script and SFTP for transferring telemetry xml files from source sites to the processing server.

Confidential

Senior Informatica Etl Developer

Responsibilities:

• Developing mappings, maplets, workflows and other components in Informatica Power Center 9.1 for Confidential project.
• Designing ETL procedures in order to implement Change Request requirements. Developing Autosys scripts and shell scripts in order to automate ETL jobs.
• Platform was Oracle 11g, SQL Server 8 and AIX. Developing data mappings using Power Exchange to transfer mainframe files to Oracle tables.
• Performing SQL tuning of the PL/SQL packages.
• Writing and tuning Oracle stored procedures to implement ETL processing to dimension and fact tables.

Confidential

Senior Informatica Etl Developer

Responsibilities:

• Working with Cognos developers and analyst in order to prepare ETL jobs for loading data for reporting. Fine tuning long running SQL statements and PL/SQL packages.
• Developing mappings and workflows in Informatica Power Center 9.1 and PL/SQL packages for Pharmacy Claims Platform Change project for Tufts Health client.
• Using Informatica versioning option and CVS for PL/SQL change control Using Tidal for scheduling ETL jobs. Database was Oracle 11g.

Confidential

Senior Informatica Etl Developer

Responsibilities:

• Developing mappings and workflows in Informatica Power Center in order to synchronize dimension tables in different databases.
• Developing Informatica ETL procedures (mappings, workflows) for Resolink 3 and Case Resolution project. Developing korn shell scripts in AIX server in order to automate and customize Informatica ETL procedures.
• Developing PL/SQL packages for Case Merge/Unmerge procedures for Resolink 3 project.
• Unit test developed procedures. Performance tuning of PL/SQL procedures using bulk options and collections on Oracle 11g.

Confidential

Senior Etl Developer

Responsibilities:

• Migrating ETL procedures from Ab Initio to Talend Enterprise Management ETL for Prime Finance Data Warehouse. Designing procedures for partitioning large fact tables in Oracle 11g and MS SQL Server RDBMS. Developing procedures for Capacity management for analytics Data Warehouse.
• Defining and extending Enterprise Meta Environment (EME) for Prime Finance Ab Initio environment.
• Developing reports based on usage of the Oracle analytical functions (OLAP) for end users using Crystal Reports 2008. Using Oracle Discoverer for Data Mining of the Data warehouse Staging tables in order to consolidate customer’s data coming from different sources.
• Developing ETL procedures in Talend in order to extract data from large fact Sybase tables and create mappings from Sybase and SQL Server source tables. Customize Talend Java source code to improve performance of ETL procedures. Developing ETL procedures using Ab Initio and PL/SQL packages in order to load and transform data from OLTP Oracle data source to OLAP Oracle Data Warehouse staging tables.

Confidential

Senior Oracle Pl/Sql Developer

Responsibilities:

• Analyzing, designing, developing, testing and documenting Business Methods programs from detailed and high level specifications, assisting in troubleshooting PL/SQL procedures for Online Withdrawal Application. Environment was Oracle database 10g on AIX server and Windows XP and Toad 10 on the client side.
• Developing ETL procedures in Talend Open Studio in order to implement data transfer between XML files (source) and Oracle tables (target).
• Developing C and Pro*C programs in order to implement sftp data transfer between mainframe files and Oracle tables.
• Utilize IBM Rational Clear Case for problem tracking and PVCS for version control and configuration management.

Confidential

Senior Oracle/Etl Developer

Responsibilities:

• Designing and developing Oracle 10g database schema that supports automated load of XML documents into database. Developing XML document extract and import procedures using Castor open source framework and Java libraries.
• Developing ETL procedures and mappings using Talend Open Studio for loading data from source tables, performing Data Conversion and transformation using staging area and extracting transformed data into target tables.
• Developing AIX Korn Shell scripts in order to automate and schedule ETL process and integrate it with operating system environment.
• Tuning Load and Query procedures using best industry standards in order to achieve best performance.