Informatica Developer Etl

OBJECTIVE: To pursue a career as an ETL Consultant/Developer within a quality organization.

PROFESSIONAL SUMMARY

IT professional with over 15 years of experience in providing services to Financial, Retail, Utility and communication industries.

Extensive experience in designing, developing, testing, automating, scheduling and supporting financial/retail applications using ETL tool in a Datawarehouse environment using expertise in ETL, databases, UNIX and Autosys 11 Scheduling.

Extensive experience in providing end to end ETL data solutions as per business requirments for data

Integration, migration and data analysis.

Almost 5 years of experience in ETL Informatica 9.1.0 Power Center development

2 plus years of experience in Hitachi Pentaho ETL tool

Strong experience in Oracle SQL, PL/SQL Programming and data modeling

Experience in Informatica Power Exchange 9.1.0

Solid experience in Unicenter AutoSys 11 Scheduling tool including jobs development and support

8 years of experience in Unix shell Programming, awk and perl programming.

Experienced in supporting various applications and full understanding of support methodologies and processes

Solid experience in Agile and Water Fall development methodologies

Some experience in Hive and Hadoop.

Solid experience and understanding of data warehouse architecture with a dimensional data model

Strong problem analysis, root cause analysis and problem solving skills

Strong communication, interpersonal, verbal, presentation and writing skills

Excellent analytical and time management skills

Experience in JERA, GITKRAKEN, BITBUCKET

Experience in Incident, Problem, Configuration, Change and Release Management

Team player with excellent communication

EXPERIENCE

CGI, INC (November 2019–Current)

ETL CONSULTANT

Working on IGM Conversion Project W360Wealth.

Writing conversion code in Pentaho ETL tool, Unix scripting and Oracle SQL and PL/SQL

CIBC CCT-WBOT, CIBC – dates (07/15 to 09/2019) (CGI Employee)

ETL INFORMATCA DEVELOPER

Worked as an informatica Lead ETL developer on CCT-GOT IRIS application. Developed and tested efficient and scalable ETL processes using Informatica 9 Power Centre, Informatica 9 Power Exchange, Oracle, UNIX Shell scripts and AUTOSYS. Worked on various projects such as Multicurrency, Cardinal Domicile Accounts, Sundry, Fintrac, Apex and many more. Designed, developed, tested and implemented medium to complex ETL mappings and scripts to build and maintain automated ETL processes. Developed shell scripts for daily and monthly loads and wrote AUTOSYS jobs for scheduling. Shadowed Junior Programmers to enable them quickly learn coding standards and IRIS application.

Developed mappings, workflows, data maps, re-useable sessions, SQL scripts, UNIX shell scripts and AUTOSYS scheduling jobs to complete projects successfully. Automated batch processes to increase productivity and to reduce downtime and cost. Use agile development methodology to projects and code development.

Skills Used: AUTOSYS Informatica PowerCenter 9.1, Informatica Power Exchange 9.1, Oracle 11g, SQL, PL/SQL,

Unix Shell Scripting, Awk/Sed, Perl, AUTOSYS 11.0 Scheduling, Microsoft Visual Studio, Rational Clear Case, AUTISYS 11.0 Scheduling, Sun Solaris 5.8 Unix, Visio designing tool, Erwin, Microsoft Office Suite 2016 and Agile Development methodology

ROGERS – dates (03/2015 to 07/2015)

SENIOR ETL INFORMATICA SPECIALIST

Worked as an ETL Specialist and modified workflows in ODIN application to validate the promotion data file being loaded to ODIN DW using Informatica 9 mappings, sessions, SQL scripts and UNIX scripts. Load SQL scripts to load data into History tables. Performed ODIN support and fixed some ongoing SQL and Informatica mapping issues. Used Oracle 11g SQL, Informatica 9, Unix Shell scripts, Control-M Scheduling and ClearCase

Skills Used: Informatica PowerCenter 9.1, Informatica Power Exchange 9.1, Oracle 11g, SQL, PL/SQL,

Unix Shell Scripting, Awk/Sed, Control-M Scheduling, Rational Clear Case, Sun Solaris 5.8 Unix, Visio designing tool

CIBC MLIDT DEV SERVICES, CIBC – dates (09/2009 to 03/2015)

SENIOR DEVELOPER

Worked on various projects such as Trail Offer, Credit Card, PLC, FMCA, Remote Print and EDOCS. Worked on all phases of SDLC using agile methodology to load the source data into THDB database.

Analyzed business requirements and worked with business to design efficient and scalable ETL processes using Autosys, Informatica Power Center, Oracle SQL, UNIX Shell scripting, Awk, Perl and Autosys. Worked with mapping transformations such as aggregator, sorter, router, filter, join, expression, lookup and update strategy, sequence generator, mapplet and re-useable sessions.

Automated many batch processes to increase productivity and to reduce downtime and cost. Designed Process flows and workflows; and developed scripts. Worked as a lead and shadowed Junior Developers. Complete understanding of Software Development life cycle, Support Cycle, Data Warehouse concepts and ITSM.

ENMAX, ACCENTURE – dates (09/2005 to 08/2009)

SENIOR APPLICATION ANALYST

Worked as senior developer and support specialist on ENMAX Utility Application for client ENMAX. Performed development, enhancement, testing, deployment and support of ENMAX sub applications called OPUS and ERDI in a batch environment. Worked on various phases of development and support cycle of ENMAX application processes such as EPOST, GL, Opus-Rewards, TRN and DSR by developing, modifying, testing, automating, implementing and supporting in production environment. Identified, investigated and resolved technical issues and created support documents. Wrote Internal CMMI Article on CMMI Document on DAR (Decision Analysis and Resolution Process) for Accenture.

Skills Used: Oracle, SQL, PL/SQL, Unix Shell scripting, AWK, Perl, Visio, Remedy, PVCS Version controlling, TCP/IP, Crontab, AutoSys Scheduler and ITSM

PUTNAM INVESTMENT, KEANE CANADA – dates (05/05 to 09/05)

SENIOR SUPPORT CONSULTANT (Contract)

Supported Putnam Investment’s financial application with on-call production support. Modified code for VTFund, COR and Monitor_Home_Orliens processes.

Skill used: (Solaris UNIX shell, Oracle, AUTOSYS Scheduler, windows, Visio )

EMC, EMC CORPORATION –dates (09/2003 to 10/2004)

SENIOR TECHNICAL CONSULTANT

Provided T2 and T3 technical support for Documentum eRoom collaborative application.

Handled variety of technical issues for customers including complex issues, and issues that were ambiguous and required identification and resolution.

WILDFIRE, THOMSON REUTERS – dates (Dec 2000 to June 2002)

DATABASE DEVELOPER (Contract)

-Worked on a wildfire project, ETL Load Process and developed SQL, PL/SQL procedures, UNIX shell scripts and XML to load data into Oracle Wildfire database into CLOBs after extracting, cleansing and transforming Data coming from different hubs. Worked on porting programs from Pro*C and SQR into Oracle 8i database.

HERZING IT College –dates (Dec 2000 to June 2002)

Oracle SQL, PL/SQL instructor (Contract)

Provided training to students on Oracle SQL, PL/SQL and Database Architecture

SDG (DIV. OF NCR CORPORATION) –dates (Nov. 1997 to Nov. 1999)

PROGRAMMER/ANALYST

-Worked on OfficeMax project designed, customized and tested replenishment PO logic using Micro Focus Cobol,

UNIX shell scripts, Oracle SQL Plus and PL/SQL procedures.

-Worked on L.C.B.O project and customized two SDG forecasting modules using Pro*C and Oracle SQL

-Worked on Camelot project & customized Suggested Order logic & sales policy using COBOL and Shell Scripts

-Ported SDG replenishment software from Oracle server to IBM UDB DB2 RDBMS Server

EDUCATION

M.S. Computer Science, Queens College, CUNY, USA (Master Level Courses Completed) 1993 -1996

MSc. Masters in Mathematics –Karachi University- PAK. (1990)

TRAINING AND COURSES

Business Analyst Certification –All 5 courses (University of Toronto, Canada) 2008.

Informatica ETL Power Center Level 1 Developer Certificate (Informatica University) February, 2011.

Informatica ETL Power Center Level 2 Developer Certificate (Informatica University) September, 2014.

HDP Developer: Apache Pig and Hive Training Course (HortonWorks University) October 24, 2016

Contact this candidate