Senior Etl Engineer Resume
SUMMARY:
- Around 9.5 Years of solid IT industry experience with 8.6 years of extensive experience as a LEAD in Informatica PowerCenter , Data Warehousing and Data integration projects.
- Informatica Certified Specialist Developer .
- Expert knowledge in Informatica development and also in support .
- Strong knowledge in ETL Concepts of Powercenter Informatica Designer, Workflow manager, Workflow Monitor and Repository Manager .
- Well versed with Data Warehousing concepts and ETL designs for loading Star Schemas/ Snowflake schemas .
- Sound knowledge in PowerCenter transformations .
- Expert level understanding and hands on Performance tuning of mappings / sessions in Informatica PowerCenter.
- Strong hands - on in Oracle 9i, 10g, 11g and on PL/SQL, Functions, Procedures, Triggers and Cursors.
- Advanced development and implementation knowledge in informatica mapplets , SQL overrides, load types, session partitioning.
- Sound knowledge on Data warehouse development and complex requirements using Informatica PowerCenter and also for Strategy, System Management and for System support.
- Advanced expertise in developing complex SQL code.
- Sound knowledge in SQL query optimization and performance tuning.
- Very good Debugging skills in issues pertaining to Oracle and Informatica PowerCenter.
- Suggested several design based good practices to clients in implementation of ETL using Informatica PowerCenter.
- Strong knowledge on System Integration and how to work with several systems to gather meaningful data and integrate to the technical systems while parallely doing the impact analysis.
- Experience in designing data models using approaches eg: Kimball.
- Good experience in Data analysis and develop data models.
- Extensively performed Unit Testing, System Testing, Integration testing, Functional testing and User Acceptance Testing (UAT).
- Sound experience in adhering to ETL standards and designing ETL process and ETL frameworks to help reusability.
- Well known skill for issue resolution till the closure.
- Good Team management capability.
- Knowledge of programming languages and how to use them in combination with ETL processes based on Informatica PowerCenter.
- Healthcare and Telecom principles and domain expertise.
TECHNICAL SKILLS / HIGHLIGHTS:
ETL Tool : Informatica PowerCenter 9.6.1/ 9.5.1 /9.1.1 / 8.6
Database : Oracle 9i / 10g / 11g
Tools : Informatica PowerCenter Suite 9.5.1, Toad, SQL Developer, Putty, PL/SQL Developer
Operating Systems : UNIX, Windows XP, Windows 7, Windows 8.1, Windows 10
Version Control : Rational Clearcase, Tortoise SVN, Microsoft Visual Source Safe
Scripting : Basic Python & Unix Shell scripting, Informatica Certified Specialist, Analytical Problem Solving Capabilities
Bug Reporting Tools : HP Quality Center, Excel
Languages : C, SQL
Job Scheduler : Informatica inbuilt, $Universe, CA ESP scheduler Change Data Capture (CDC)
Big Data tools: HIVE
PROFESSIONAL EXPERIENCE IN PROJECTS:
Confidential
Senior ETL Engineer
Responsibilities:
- Implement several good practices for ETL to achieve near real time SLA for necessary loads.
- Analyze several flows and check for the integrity of data using informatica.
- Schedule the data loads accordingly and solve business queries to handle revenue data properly.
- As a data engineer, we need to understand the full stack of data where it gets generated and where does it flow and there by gather it from required sources.
- Gather the data and write code to transform the data into required format and then write to Vertica database for analytic purposes.
- Implement data quality rules for the incoming data from several sources and also maintain non-redundant data.
- Design database tables to customize the meaning of user data and to be utilized for many purposes.
Solution Environment :: Informatica, Oracle, Vertica, Hive, Python framework.
Tools : Informatica 9.6.1, DQ check by IDQ, DBVisualizer for sql, Sublime text as editor, several custom built tools for accessing data from different Hadoop and BigData sources (presto) etc, MAC OS X.. .
Confidential, Portland, OR
Lead Consultant Developer
Responsibilities:
- Lead and also Senior Developer for ETL Processes.
- Designer / Presenter for the ETL flow of new business requirements.
- Worked on developing different frameworks for error handling, dynamic parameterization.
- Worked to develop data cleansing methods to store relevant information and synchronous across databases.
- Use best practices and reuse code snippets for making the code performance better.
- As a senior developer, responsibilities include discussion with business managers and take the required inputs as per the requirement.
- Assigning tasks to the respective individual team members based on the required deliverables to satisfy a lead responsibility.
- Extensively involved in developing the ETL logic to do the Auditing and Error Handling for the loads happening across different projects using Informatica PowerCenter.
- Code and automate several archival mechanisms and dynamic file changing using Python.
- Passionately drive the development and give the top notch delivery.
- Developed the ETL code in Informatica PowerCenter and also have tested ETL datawarehouse components.
- Test results to be captured and documented thoroughly.
- Worked on complex business requirements to satisfy the stringent rules proposed from the administrators point of view and yet achieve the desired functionality.
- Work on adhoc issue resolutions and thoroughly unit test the code.
- Properly guide the QA team about the various issues and help them understand the business functionality.
- Review the code developed by other team members.
- Suggest any performance oriented approaches as applicable.
- Always deliver and stay on top of Informatica PowerCenter development and support related issues.
Solution Environment : Windows 7, Informatica PowerCenter 9.5, UNIX, Oracle SQL, Informatica Data Quality.
Tools: SQL Developer, Quality Center for bug tracking.
Confidential, Denver, CO
Sr. Informatica Developer
Responsibilities:
- Senior ETL Developer and Tech. Coordinator for 5 people.
- Working on Dynamic requirements, which need to be acted up on in stringent timelines.
- To interact with Client directly and discuss any on-going issues and provide guaranteed solutions that are destined to work.
- Discuss with team and get the doubts clarified before going to start their daily activities.
- Assigning tasks to the respective individual team members based on the required deliverables.
- Worked on migration Proof of Concept for repository migration from 8.6 to 9.1.
- Involved in improving the QA Process.
- To use shell scripting for effective handling of triggrer and data archival process.
Solution Environment : Windows XP, Informatica PowerCenter 9.1, UNIX, Oracle SQL.
Tools: CA Harvest SCM Workbench (for source code control)
Confidential, Louisville, KY
Sr.Informatica Developer
Responsibilities:
- ETL Development in Informatica PowerCenter according to the changing business needs which come down as stories and sprints. The project works on Agile methodology unlike the conventional waterfall model.
- Track the status of each day change and delivery.
- Work on proof of concepts to tune the existing ETL processes.
- To schedule jobs in $Universe scheduler for running informatica Powercenter workflows / jobs.
- Understanding the business requirement and the functional requirements.
- Extensively worked in data Extraction, Transformations and Loading from different source system and manipulated ETL-logic to Target system tables
- Developed PL/SQL Procedures and packages and using in informatica pre/post session routines SQL for metrics calculation.
- Created command tasks using informatica powercenter workflow-designer and execute the corresponding Python scripts.
- Used Informatica PowerCenter for Extraction, Loading and Transformation(ETL) of data in the data warehouse.
Solution Environment : Windows XP, Informatica PowerCenter 8.6, Oracle SQL, UNIX, $Universe Scheduler, Enterprise Turn Point, Teradata 13.0.
Confidential
Informatica Developer
Responsibilities:
- Preparing Data builds for new change requirements and work on Informatica powercenter development.
- Handling ORT calls with customers and participate in design activities pertaining to Informatica powercenter.
Solution Environment : Windows XP, Vista, SQL, UNIX, Informatica PowerCenter 8.1, 8.6
Tools: Tortoise SVN (for source code control)
Confidential
Informatica Developer
Responsibilities:
- Design and develop Informatica PowerCenter Mappings.
- Performance Optimizations of mappings by creating indexes, identifying bottlenecks etc.
- Maintain the known error database for troubleshooting.
- Debugging queries & blocks in the PL/SQL code for activities related to Inventory & Order Management.
- Used Informatica PowerCenter for Extraction, Loading and Transformation (ETL) of data in the data warehouse.
- Used most of the Transformations such as Source Qualifier, Aggregator, lookup, Filter, Joiner, Sequence generator, Router, update strategy etc.
- Used session parameters, Mapping variable/parameters and created parameter files for flexible runs of workflows based on changing variable values.
- Involved in Optimizing and performance tuning logic on targets, sources, mappings, and sessions to increase the efficiency of session.
- Reloading data for failed Informatica PowerCenter workflows and finding out RCA.
Solution Environment : Windows XP, Vista, Informatica PowerCenter 8.6, PL/SQL, UNIX basics
Tools: Microsoft Visual Source Safe (for source code control)
Confidential
Informatica Developer
Responsibilities:
- Involved in execution of the Cmo to Walky10 migration for different circles.
- Involved in Cmo to VDATA migration activity.
- Used Informatica PowerCenter for Extraction, Loading and Transformation (ETL) of data in the data warehouse.
- Used most of the Transformations such as Source Qualifier, Aggregator, lookup, Filter, Joiner, Sequence generator, Router, update strategy etc.
Solution Environment : Oracle 9i SQL, PL/SQL, UNIX, Informatica Basic transformations.
Tools: Rational ClearCase Explorer (for source code control)