Etl Developer Informatica

Nithin Achuthankutty ETL Developer +414-***-**** *******@*****.***

Highly motivated and detail-oriented ETL Developer with 11 years of IT experience with primary skill set of Informatica, SQL and Shell scripting and working with varied Program and Organizations in the domains of Retail and Insurance, Healthcare and Banking. Prime focus on Design, Development, Maintenance and Enhancement of ETL applications. Excellent hands on development, technical and team leadership, focused on timely delivery and quick return on investment (Using Waterfall/Agile/SAFe Framework. Well accomplished in governance of Program using the Agile Ceremonies and working with a diverse variety of Distributed teams.

Technical Skills

Business Modeling Tools

MS Visio

Management Tools

MS Project professional, JIRA Align, TFS, Wiki, SharePoint

Technologies/ Languages

SQL, Unix/Linux Shell Scripting, Macros

Project Methodology

Software Development Life Cycle (SDLC), Agile/Kanban/Scrum, SAFe and Waterfall, ATDD, TDD, DevOps

ETL Tools

Informatica Power Centre 6.2/7.1.3/ 8.1/9.1/9.5,Power BI, Erwin, SSIS, Informatica MDM

Database

DB2,SQl Server, Oracle 9i/10G,Big Data

Other tools

Toad for Oracle 8.6, Control M, Clear case, CA Workload, Putty, Autosys, Gitbab/Github

Professional Experience

Mercury Insurance Dec 2020 – Current

ETL Lead

Environment: Erwin, Informatica 9x, DB2, DBVisualiser, Unix/Linux, PowerBI, Tivoli, Redshift

Mercury Insurance is an insurance company formed out of Los Angeles, California in 1962 by Mr. George Joseph. Its goal is to provide quality insurance and customer service at fair prices for the average driver. There are plenty of large auto insurance providers out there, including USAA, Geico, and Farmers.

Roles & Responsibilities:

• Generating Informatica mapping and loading the data to AWS Redshift and generating reports.

• Push down Optimizations mechanism by creating queries and pushing them to source to improve the performance.

• Documenting and updating the deployment plan, test plans, design plans, production support plan etc.

• Working closely with the business users to understand the requirements and converting them into project level technical capabilities.

• Experience building OLTP, Relational Database Models and ETL data warehouse.

• Data Modeling using Dimensional Data modeling, Star/Snowflake Schema modeling, FACT and Dimensional tables, Physical and logical data modeling, using Erwin.

• Maintained UNIX Shell scripts for data integration flow from outside sources to load into ETL for pre/post session operations and various day-to-day operations using Informatica power center 10.2.

• Collaborate and work with business analysts and data analysts to support their data warehousing and data analysis needs.

• Informatica workflow manager & monitor to create, schedule, monitor workflows and has worked on heterogeneous data sources, like flat files.

Northwestern Mutual Nov’2017 – Dec’ 2020

Developer Lead

Environment: Erwin, Informatica 9x/10x, DB2, Unix/Linux, PowerBI, Autosys, AWS S3 Bucket

Northwestern Mutual is an American financial services mutual organization based in Milwaukee. The financial security company provides consultation on wealth and asset income protection, education planning, retirement planning, investment advisory services, trust and private client services, estate planning and business planning. Its products include life insurance, disability income, and long-term care insurance; annuities; investments; and investment advisory products and services.

Roles & Responsibilities:

• Instrumental in identifying/analyzing the sources create necessary documentation for the development teams; design the table structures, guide team with ETL solutions for field forces.

• Maintained UNIX Shell scripts for data integration flow from outside sources to load into ETL for pre/post session operations and various day-to-day operations using Informatica power center 10.2.

• Documenting and updating the deployment plan, test plans, design plans, production support plan etc.

• Designated owner and accountable for major tasks and took responsibility for actions and outcomes to ensure timely and cost-effective results for our team.

• Work with peers from various functional areas to define IT wide processes like code reviews, unit test documentation and knowledge sharing sessions.

• Collaborate and work with business analysts and data analysts to support their data warehousing and data analysis needs.

• Provide/update common business vocabulary and inventory of data structures using Common Data View, Core Data Model with Erwin and Rochade.

• Converting the existing on premise SFTP job to Cloud SFTP transfer and placing the files in AWS s3 bucket and having EC2 instance.

• Creation of report for Adhoc request and for dashboard creation using Power BI.

• Automation of code deployment using CICD.

• Informatica workflow manager & monitor to create, schedule, monitor workflows and has worked on heterogeneous data sources, like flat files.

John Hancock Life Insurance Oct’14 – Nov’17

ETL Developer

Environment: Informatica 9.1.0, SQL Server 2008, Oracle 9i, UNIX, Clearcase, CA workload, Putty

John Hancock is dedicated to providing thoughtful and innovative insurance solutions designed to help you address a variety of financial planning goals and needs, including protecting your family's well-being and assets, growing your retirement savings, and preserving a legacy for future generations.

Roles & Responsibilities:

• Develop and deploy integrated solutions aimed at modernizing, consolidating and coordinating vendor and independently designed applications across the enterprise to meet business needs.

• Accountable for assessing the impact of change on application/systems to support and maintain performance, availability and data accuracy.

• Convert High level architectural design to a detailed application design; may include software product evaluation and buy vs build recommendations also includes efficient reuse of existing components.

• Tuning the Informatica mappings and SQL's for optimal load performance Involved in the production support, watch the workflow monitor carefully to see all workflows and all Tasks are running properly and data is loading in the proper way and to the right targets and at the right time.

• Handling daily status and issue call with client along with Team.

• Worked extensively to support the 24x7 application by putting in data quality checks, day over day validations to ensure data completeness and integrity.

• Designated owner and accountable for major tasks and took responsibility for actions and outcomes to ensure timely and cost-effective results for our team.

• Performing tuning of queries in oracle & SQL server databases to improve the performance.

WellPoint Health Networks Inc Apr’14 – Sept’17

Sr. Software Developer

Environment: Informatica 9.1.0, DB2, UNIX, Control -M

Deliver a Consolidated Provider Data System for the Enterprise that will accommodate current and future Provider Demographic Data and Network Affiliation needs for all states and that will serve as a Centralized Source of Truth for Provider Data.

Roles & Responsibilities:

• Gather information and business requirements from clients through regular meetings and verify the requirements completely and these requirements are reviewed and formally approved.

• Designing and developing ETL mappings keeping in view of performance criteria.

• Involved in testing and Informatica mappings with manual testing and assigned QA team and used SQL tools like TOAD to run SQL queries and validate the data loaded into target tables.

• Used Informatica Workflow Manager & Monitor to Create, Schedule, Monitor workflows.

• Finding the errors when session fails and rectifying the same ASAP.

• Working with data and ETL architects to helps design an optimal solution.

• Perform root-cause analysis of identified issues that arise post-implementation and work on solution related to issues.

• Accountable for assessing the impact of changes on applications/systems to support and maintain performance, availability and data accuracy.

• Handling the job scheduling through control-M.

• UNIX Shell scripts creation for data integration flow from outside sources to load into ETL for pre/post session operations and various day-to-day operations using Informatica power center.

Americo Life Insurance Company Nov’11 – Apr ’14

ETL Developer

Environment: Informatica 9.1.0, SQL server 2008, SQL TOOLS

Americo is one of the Leading Company providing the insurance to the customers in USA. They are having the Business of Life 70(L70), Vantage and New Business Underwriting (NBU), Policy Administration System (PAS) and New Business under Workbench (NBUW) and getting the customers for those businesses by Americo Agents and the Agents are getting Commissions from the Client for the Insurance policies providing by them. So this SRS system is built in order to calculate and analysis the Sales activity of these businesses by Agent and policy Level. This System is Developed based on ACCORD Insurance Standards.

Roles & Responsibilities:

• Working on mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Rank, Sequence Generator, and Update Strategy.

• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, sequence generator and joiner.

• Set and followed Informatica best Practices, such as creating shared objects in shared for reusability and standard naming convention of ETL objects, design complex Informatica mappings, mapplets, reusable sessions, worklets and workflows.

• Monitoring jobs every day using Workflow monitor.

• Working on heterogeneous data sources, like flat files.

• Working on the daily tickets and issues.

• Involved in writing UNIX scripts to run and schedule batch jobs.

• Involved in the extraction of data from SQL server database through web service and loading into relational targets.

Barneys New York Aug’10 – Oct ’11

ETL Developer

Environment: Informatica 8.6.1, Oracle 10g, MSSQL, UNIX, SQL TOOLS

Barneys New York has engaged to define and design a new Digital Platform solution based on the ATG E-commerce Product Suite for Barneys New York that will support its current and future multi-channel commerce requirements. The Digital Platform will be implemented in 3 major releases (Release 1, Release 2 and Release 3). Release 1 will focus on a mobile browser based shopping experience. Release 2 will focus on mobile application based shopping experience. Release 3 will involve the launch of the browse, shop and buying experience on the web channel (Barneys New York.com) as well as foundational capabilities in social and in-store experience. Project deals with whole Staging, PBCC, BCC development activities.

Roles & Responsibilities:

• Designed the Mapping Technical Specifications on the basis of Functional Requirements.

• Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, MSSQL, Oracle into a common target area such as Staging, PBCC and BCC.

• Involved into source code review, the mappings created by my team members.

• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time.

• Tested the Informatica mappings with manual testing and assisted QA team.

• Developed different mappings by using different Transformations.

• Involved in performance tuning by optimizing the sources, targets, mappings and sessions.

• Used SQL tools like SQL TOOLs, to run SQL queries and validate the data loaded into the target tables.

AKN Bank Turkey Jul’09 – Jun ’10

Software Developer

Environment: Informatica 8.1, Oracle 10g, UNIX, TOAD

AKN Bank DWH project take care of minor and major enhancements, problems and incidents in AKN Bank DWH area. Project deals with whole DWH and 8 Data marts development activities.

Roles & Responsibilities:

• Designed the Mapping Technical Specifications on the basis of Functional Requirements.

• Involved into source code review, the mappings created by my team members.

• Prepared deployment document and assisted to deployment team while migration

• Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, Oracle into a common target area such as Staging, Data Warehouse and Data Marts.

• Developed different mappings by using different Transformations.

• Used SQL tools like TOAD to run SQL queries and validate the data loaded into the target tables.

Rockwell Electronics Aug’08 – Jun ’09

Software Developer

Environment: Informatica 8.1, Oracle 9i, UNIX, TOAD

Generally Rockwell electronics, New York, USA does not have a manufacturing unit, What BIZ (Business) use to do here is before quarter ends they will call for quotations for primary supply channels this process we called as a RFQ’s (Request for quotations).Once BIZ creates RFQ automatically notification will go to supply channels .So these supply channels send back their respective quoted values that we called it as response from the supply channel. After that biz will start negotiations with supply channels then they approve the RFQs.

Roles & Responsibilities:

• Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, Oracle into a common target area such as Staging, Data Warehouse and Data Marts.

• Tested the Informatica mappings with manual testing and assisted QA team.

• Designed the Mapping Technical Specifications on the basis of Functional Requirements.

• Extensively used Informatica client tools – Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.

• Developed different mappings by using different Transformations.

• Used SQL tools like TOAD to run SQL queries and validate the data loaded into the target tables.

Education

Bachelor of Electronics & Communication Engineering - Cochin University of Science and Technology, India - 2008.

Contact this candidate