Data Developer

OBJECTIVE:

ETL/Data Developer

HIGHLIGHTS OF QUALIFICATIONS

6+ years of experience in Information Technology working as a ETL / Data developer for Banking, Insurance, Finance and Telecom industries

Working experience in ETL design, development and implementation of complex mappings in Informatica using PowerCenter Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager and Workflow Monitor.

Working experience with various mapping developments between source systems and ODS, Data Marts, data cleansing, data staging and Data integration of various data sources to meet functional requirements

Hands on experience with Data Profiling/Data Quality using Informatica Developer, and BDM tool

Working experience in various development and maintenance projects from small to large scale, adhering to software development life cycle and ensure the quality of deliverables by Unit test, module testing, functional testing, integration testing, regression testing, Data warehouse testing and Data analysis and providing technical support to QA team

Working experience with supported for migrating Informatica 9x ETL code to Informatica 10x and prepared required documents for data migration

Strong experience in translating functional specifications into technical design documents, technical objects, supporting technical design, development and implementation as a senior developer

Experienced in writing Unix Shell Scripts for the automation of ETL processes and using schedulers like ZENA and Ctrl-M

Working experience with Source Tree. GIT hub and Bit Bucket Tools

Working experience with Big data technologies Hadoop, HDFS, Hive and Impala

Experience with working on a Scrum Agile team and JIRA Tool

Working experience with BSAs, IT consultants, Business Analysts and handling day to day interactions with respect to technical clarifications, constraints and other deliverables

Extensive knowledge and experience using ETL tools Informatica 7x, 8x, 9x,10x, SSIS, DBMS tools Oracle 9i/10g/11g, Teradata, DB2, SQL Developer, SQL DTS, MS SQL, Software methods SDLC, ERWIN, Agile, Operating systems Win XP, UNIX, Programming languages Java and C++

EMPLOYMENT HISTORY

Project # 5: Horizon Finance Enterprise Data Warehouse (EDW) at Aviva Canada

August 2018-till date

Worked with Billing Centre source system(Storage of real time financial transactions)

Guidewire Billing centre have plug-in that convert financial transactions in to xml payload and then they are stored in Integration Database (IDB) and Integration with external payment processing system and Oracle Financials

Extracted Source data like from XML payloads, excel, csv, Oracle and load into Integration Database (IDB) tables as per the Business requirements.

Provided support for Informatica workflows/mappings which are running into Production environment

Tuned Informatica mappings for optimum performance

Designed and developed Oracle PL/SQL Scripts for Data Import/Export, Data Conversions and Data cleansing

Liaised with DBA to incorporate requirement changes at database level for Development, QA and Production environment

Populated error tables as part of the ETL process to capture the records which are failed during the loading process

Worked with UNIX shell scripts for updating parameter file and file transfers and file generation

Worked with Source Tree and Bit Bucket tools to check in the database scripts

Tested the target data against source system tables data

Modified existing mappings for enhancements of new business requirements and to improve the performance of the daily jobs, like load XML payload source data to IDB table and replace the XML payloads in the mapping with IDB table as sources for all the mappings

Worked with Zena tool for Scheduling Informatica jobs

Worked on Deployment of code to produce Reconciliation totals, Quality Metrics and Load Statistics.

Support Project:

Project # 4: EPAM and SolvencyII at Aviva Canada

August 2018-till date

Provided month end and quarterly end support for ePAM, UGL and solvency II jobs which ran on Teradata and Informatica.

Provided support for migrating Informatica code to BDM.

After migrating code to BDM and Hive, providing production support to ePAM, solvency II applications.

Resolved production issues at Teradata and BDM level as part of support.

Worked with Zena tool for Scheduling Informatica jobs

Provided analysis on the field mappings for EPAM, UGL, solvency-II applications based on demand request from Business

Analysed and prepared required documents for support.

Project # 3: MTN EDW2 (Mobile Telecom Network) at MTN (Mobile Telecom Network) South Africa – Tata consultancy services August 2012-June 2014

Participated in functional requirement walkthroughs and responsible for translating functional Requirements to technical requirement

Designed and developed Informatica Mappings between Source systems to ODS and then to Data Mart

Improved the performance of Informatica mappings using Parameter files, Variables and Dynamic Cache. Created parameter files and script files (ex: Date updating scripts) in UNIX

Developed Stored Procedures to transform Data and worked with PL/SQL for various transformations for loading data in to target layers

Extensively worked with Performance tuning on Informatica mappings, databases to

ensure faster recovery and improve better performance

Optimized the processing by determining where and when processing occurs by setting the Client/database option

Responsible for design and development of data mappings, mapplets and sessions for loading data into target databases using Informatica PowerCenter, and responsible for performance improvements

Working experience with end to end Design, Construction, Unit testing and all phases of software development life cycle and various methodologies

Import of Sensitive Production Data to Lower Environment for testing using TCS Master Craft Data Masker.

Ensure Complete System Stability by Root Cause Identification of Production Processing Issues and Provide Optimum Solutions by interacting with real Business users.

Supervise and Complete monitor to ensure that necessary delivery details are provided to Testing team till project hit production

Analysed the existing legacy systems and the business user requirements for tactical and strategic needs

Provided support for Informatica workflows/mappings which are running into Production environment at client location

Project # 2: Westpac-OTP (Online Transformation Program) at Westpac Banking Corporation, Sydney – Tata consultancy services July 2011-July 2012

Involved in Debugging activities for defects/issues, impact analysis, testing of stored procedures and functions built, testing of Informatica sessions, batches and the target data

Documented user requirements, translated requirements into system solutions and develop implementation plan, scheduled and maintained standard naming conventions

Worked with different data sources such as Oracle, MS SQL Server, XML and flat files

Worked with workflow manager for scheduling, session management, and database connection management and scheduling of batch jobs to be run in the batch process

Performing impact analysis and updates to existing mappings for enhancements of new business systems requirements

Worked with UNIX shell scripts for updating parameter file and file transfers and file generation

Involved in code Review. Created and Executed the Unit Test scripts.

Acted as Learning and Development co-ordinator, conducted Informatica trainings for the team members, facilitate workshop sessions

Project # 1: Bank of America -Critical Data Management at Bank of America -USA – Sigma Edge June 2010-June 2011

Experienced in Full Life Cycle projects for the Development of Operational Data Systems (ODS), Data Marts & Enterprise Data Warehouses and Reporting of data marts required for critical business applications in the Banking domain

Participated in ETL Design, Development and Validation of Informatica Mappings and Workflows

Experienced in developing complex mappings, having good workarounds for effectively implementing SCD Type I, Type II, Type III and any complex logics in Informatica as part of the ETL process during the development of Data warehouses

Possess strong knowledge in optimizing developed program logics for performance and good experience in developing mappings for the given logic without using costlier transformation as a performance tuning measure

Created and Executed the Unit Test scripts.

EDUCATION AND CERTIFICATION

Master of Computer Applications (MCA), JNTU September 2006- May 2009

Certified in Retail Banking functions and Delivery channels October 2011

STATUS: Permanent Residence June 2016

Contact this candidate