SUMMARY

• Having around 14 years of IT experience with primary focus on Application Development, Maintenance & Production Support projects in ETL, IBM OS/390 Mainframe environment, Python.
• 10+ years of ETL experience using Informatica Power Center, Informatica Data Quality and Data Warehousing/Business Intelligence Practice
• 4+ years of experience of working on Data quality tools like Informatica Data Quality and data profiling
• Worked on optimizing SQL queries, ETL Jobs and Data Warehousing Testing
• Strong skills in Data Requirement Analysis and Data Mapping for ETL.
• Strong knowledge in Database Design and SQL.
• Strong knowledge on optimizing SQL queries, ETL Jobs and Data Warehousing Testing
• Experienced in scheduling Sequence & parallel jobs using UNIX scripts and scheduling tool Control - M
• Development and integration experience with the various data sources like DB2, MongoDB, Oracle and flat files.
• Exposure to complete Software Development Life Cycle (SDLC) based on a Waterfall, Agile/Scrum Software development methodologies.
• Worked extensively on ETL process using Informatica Powercenter (v 10.1,9.6,8.5,7.1) and Informatica MDM v10.1
• Strong knowledge on designing new systems based on business requirements and capable of giving quick solutions.
• Extensive experience on working with Migration projects.
• Experience in implementing full cloud based application using Python, Spark, MongoDB, Flask.
• Exposure in Mentoring New Joiners and Training them for the Project
• Excellent qualities such as teamwork, leadership, negotiation, analysis, and communication with clients.
• Part of SME panel in brainstorming technical solutions and knowledge sharing sessions
• Strong time management skills-able to take prioritize on tasks to meet competing deadlines
• Responsible for the delivery of projects from initiation through development, go-live, and user adoption
• Excellent communication, interpersonal, analytical skills and strong ability to deal wif all levels of business to convey ideas, recommendations and solutions wif ease
• High attention to detail to ensure produced work is consistently accurate and meets protocols and standards

TECHNICAL SKILLS

Languages: Python, SQL, PL/SQL, REXX, COBOL, EGL, JCL

Machine Learning Tools: Numpy, Pandas, SciKit Learn

ETL Tools: Informatica v 10.1,9.6,8.6,7.1 Informatica DVO Informatica Data Profiler v 9.1 Informatica MDM Business Objects Data Integrator MSBI- SSIS, SSRS 2005/2008/2012 Data stage v9.1,8.5 Crystal Reports 2011/2008 Tableau 10,9.3, Spark (PySpark)

Scripting: UNIX Shell Scripting

Data Modeling: Relational Modelling, Dimensional Modelling (Star Schema, Snow-Flake, FACT, Dimensions), Physical, Logical Data Modelling, and ER Diagrams.

Databases: - Db2, MongoDB, Oracle PostgreSQL v9.6 Greenplum v5.7 IBM Db2 v10.5 Oracle 9i, 10g,11g SQL Server 2005, 2008,2010 Sybase MS Access Teradata V2R5 Gennetica Systems Pega Systems

Version Control: GIThub, Endevor, Informatica Versioned Repository

Cloud Application: Pivotal Cloud, Azure, Docker, Kubernetes, OpenShift

Business Process Management: Pega

IDE: RBD, RDz, PyCharm, Spyder

Other tools: Docker Container, Robo 3T, Studio 3t, Interest, Platinum, MAPR, File Master, Oracle SQL Developer, Teradata SQL assistant, Service Now, Jira, Jenkins.

PROFESSIONAL EXPERIENCE

Confidential, NJ

LEAD/Senior ETL Informatica DEVELOPER

Responsibilities:

• As a Technical Lead, responsible for Analysis, Design, Project delivery in Agile methodology and managed team in both Onshore and Offshore.
• Provided technical solutions and strategies to the application development problems
• Designing and implementing ETL
• Creation of ETL and ETL code in Informatica to manage data integration tasks within the project team
• Status reporting and responsible for the final delivery.
• Implemented POC to migrate the application to advanced technology involving Spark, Python.
• Involved in the creation of DB design, server design through ETL.
• Responsible for creating implementation plan and back out plan for production rollout.
• Involved in the performance tuning of the SQL and ETL process.
• Prepared Job dependency document to schedule Jobs for Control-M team
• Designed Be-spoke and Black Box Code Solutions using ETL and ELT frameworks while implementing enterprise Data Warehouses and Data Marts
• Worked extensively on ETL process using Informatica Powercenter (v 10.1,9.6,8.5,7.1) and Informatica MDM v10.1
• Designing and implementing ETL and MDM solutions
• Worked on the full project life cycle from requirement analysis, design, coding, testing, QA support, production deployment and warranty support.
• Implemented full rest service using Python, Flask & Mongo.
• Developed code in Informatica using ETL.
• Used JIRA for the sprint assignments and completion.
• Created automation tool to assist in Stored Procedure testing.
• Maintaining the code versions using GitHub, Endeavor and Informatica versioned Repository.
• Share the monthly report to the Management team.

Confidential | Franklin Lake, NJ

Senior ETL Informatica Developer/Lead

Responsibilities:

• Served as Lead for the production support team.
• Involved in analysis and resolution of production tickets submitted by the business team.
• Handled weekly status meeting and keep track of status of the tickets, dependencies, short term fix and Permanent fix.
• Shared the weekly metrics to the management team.
• Prioritized the ticket based on the criticality.
• Provided the short term fix for the critical issues while the permanent fix is applied.
• Implement automation for the SOP activities.
• Created Autosys scripts to run ETL Informatica and other shell jobs
• Designing and implementing ETL and MDM solutions
• Implementing and testing Informatica based ETL solutions using generic and be-spoke methods
• Worked on optimizing SQL queries, ETL Jobs and Data Warehousing Testing
• Handled the tools Remedy and Service Now to keep track and fix the issues within the time mentioned in Service Level Agreements (SLA).
• Used JIRA for tracking the permanent fix.
• Handled on call production support.

Confidential

Senior Software Developer

Responsibilities:

• Understand the requirement document
• Prepared analysis document and review with SME
• Provided estimates, include target date
• Implemented ETL mappings using Informatica and reports using SSRS & Crystal reports.
• Prepared functional design documents and technical design specifications based on teh requirements for ETL Process
• Designed and implemented ETL solutions in Informatica Powercenter
• Performed Data cleansing process and prepared ETL mapping specifications.
• Prepared High level and low level design doc based on complexity of requirements
• Completed development, unit testing, interface testing and system testing
• Involved in development/enhancement of applications using JCL, COBOL, DB2 in Z/OS system.
• Unit and System testing of programs.
• Assumed responsibility for the maintenance and operation of the Defect Reporting System, a major Quality tracking and reporting system.
• Tools and Technologies: Z/OS, COBOL, DB2, store procedures, JCL, TSO/ISPF(File Manager), IBM Utilities, SQL, Expediter.

Confidential

Application Developer

Responsibilities:

• Analyzed and documented the business logic in the legacy MQ service.
• Provided estimates, include target date
• Prepared High level and low level design doc.
• Developed online services using CICS, COBOL, XML and DB2.
• Completed the performance analysis of the new service.
• Involved in unit testing, interface testing and system testing
• Prepare the release plan and deploy the code in production.
• Discussions with System Architects to prepare the System Design Document and get it approved.
• Prepared test scripts and gave knowledge transfer to testing team in order to facilitate System Integration, Performance and Regression testing in testing environment.
• Performed performance measures by different process and made query tuning to attain good response time.
• Implemented code to production.
• Post Production Support.