We provide IT Staff Augmentation Services!

Senior Etl Engineer Resume

Menlo, ParK

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.
  • Having in depth Informatica development knowledge and also worked in support.
  • Strong Hands - on experience with ETL Testing and tools 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 and also Workflow manager, Repository manager, Workflow Monitor.
  • Good 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.
  • Strong implementation knowledge in informatica mapplets, SQL overrides, load types, session partitioning.
  • Sound knowledge in SQL query writing and Data engineering skills.
  • Very good Debugging skills in issues pertaining to Oracle and Informatica PowerCenter.
  • Experience in applying approaches such as profiling and perform the DQ checks for the data loads.
  • Good experience in concepts of Data analysis and Data modelling for mid level issues.
  • 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.

TECHNICAL SKILLS:

ETL Tool: Informatica PowerCenter 9.5.1 /9.1.1 / 8.6

Database: Oracle 9i / 10g / 11g proficiency

Tools: Informatica PowerCenter Suite 9.5.1, Toad, SQL Developer, Putty, PL/SQL Developer

Operating Systems: UNIX, Windows XP, Windows 7

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, C++, Java Basics, Javascript, SQL

Job Scheduler: Informatica inbuilt, $Universe, CA ESP scheduler

Change Data Capture (CDC)

Big Data tools: HIVE

PROFESSIONAL EXPERIENCE:

Confidential, Menlo Park

Senior ETL Engineer

Responsibilities:

  • 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: Personal Devservers managed by Chef, Framework fully custom built using Python, Informatica PowerCenter 9.6 for salesforce sources, UNIX, Vertica 7.x Analytics Database, Chronos as a job scheduling custom built product, Git + SVN source code control inbuilt into Dev Servers, Tableau & Micro Strategy for reports and dashboards, Informatica developer for Data Quality management.

Confidential

Lead Consultant Developer

Responsibilities:

  • 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.
  • To contribute to daily work by understanding new requirements and also ensure data quality with minimum checks .
  • 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.

Confidential

Sr. Informatica Developer

Responsibilities:

  • 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.
  • Used Python to validate several user files and organize them in specific area according to business requirements.
  • Involved in improving the QA Process.
  • To use Python coding for effective looping and development of different reusable portable scripts.

Solution Environment: Windows XP, Informatica PowerCenter 9.1, UNIX, Oracle SQL, Informatica Data Quality.

Confidential

Sr.Informatica Developer

Responsibilities:

  • 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

Solution Environment: Windows XP, Vista, SQL, UNIX, Informatica PowerCenter 8.1, 8.6

Confidential

Informatica Developer

Responsibilities:

  • 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

Confidential

Informatica Developer

Responsibilities:

  • 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.

Hire Now