We provide IT Staff Augmentation Services!

Senior Etl Developer Resume

5.00/5 (Submit Your Rating)

Plano, TX

SUMMARY:

Dedicated and results - driven Senior ETL Developer with 7+ years experience in analysis, design, development, testing, implementation of data warehouses and marts. Skilled and detailed oriented technical lead with a reputation for producing stellar solutions-based processes that enhance both team performances and technical efficiencies. Expert at revamping infrastructure and tools for all departments that drive revenue and increase productivity.

AREAS OF EXPERTISE & TECHNICAL SKILLS:

  • Informatica Power Center
  • Tableau
  • SAP Business Objects
  • SAP Design studio
  • IBM Infosphere datastage
  • SQL, PL/SQL
  • UNIX
  • Borland Control M
  • Netezza, DB2, Oracle
  • Borland control M
  • Hadoop, Hive

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Senior ETL Developer

Responsibilities:

  • Involved in all phases of building operational systems like analyzing the business requirements, ETL process design, data modeling, code development & testing
  • Led the team in developing and implementing frameworks for Integration & reporting process across the enterprise. created scripts using Sqoop to extract data from netezza & oracle and stored them in Hadoop file system
  • Queried tables in Hadoop file system using Hive for analytics purpose
  • Developing DataStage Sequences/parallel Jobs, reusable Sequences/jobs and Activities for daily process to loading heterogeneous data into the data warehouse. Source files include tables, delimited flat files, XML files and Sales force data.
  • Executed sequences, both sequential and concurrent for efficient execution of jobs and used other activities like Job Activity, Set Variables, Exec Command, Email Notification, Sequencer, Nested Conditions, Start Loop and Endloop.
  • Developing Informatica Mappings, Mapplets, reusable Transformations, tasks, sessions and Workflows for Daily process to loading heterogeneous data into the data warehouse. Source files include delimited flat files, and DB2 tables.
  • Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy, Union, SQL and Sequence generator.
  • Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email and command.
  • Improved and enhanced various jobs inside different cycles by creating Reusable & Common jobs technique. Extensively used parameters at run time to push in job related parameters
  • Extensively worked with DB teams for partition the tables and for tweaking the SQL queries for better performance.
  • Extensively loaded data to Netezza tables/database using Netezza connector in datastage.
  • Analyzed and identified the list of workflows, which can be run concurrently for better performance.
  • Added appropriate dependencies at job level & batch process level for each job and Quantitative resources for each database/resource pools at scheduling tool to avoid deadlocks, timeout and connection issues.
  • Integrating with the data sources (like Member data and products from various systems). Comprehensively used DataStage for loading the historical data from various tables for different Line of Business
  • Managed the authenticity of UNIX components by Checking-in & Checking-out code from StarTeam/RTC , a code versioning tool.
  • Improved Netezza query performance by troubleshooting data and execution issues.
  • Prepared Unix Shell Scripts for scheduling the jobs using Control-M.
  • Created Wisdom solution, ETL overview & Code walk through documents.
  • Code migration of DataStage/Informatica jobs from Dev, Test & Prod through release process. Ensuring the Unit testing, Integration Testing, Job & Environment parameters testing along the way.
  • Actively participated in discussions and implemented Error Handling process
  • Performed end to end operations and maintenance like iteration planning, story writing with scrum master, defining problem/project scope, writing measurable goals, acceptance criteria, design, development, testing, retrospective meetings, code move procedures, implementation, warranty support and maintenance
  • All Projects have been delivered using agile methodology

Confidential

Senior ETL Developer

Responsibilities:

  • Involved in all phases of ETL process design, code development, testing and production support
  • Developing DataStage Sequences/parallel Jobs, reusable Sequences/jobs and Activities for daily process to loading heterogeneous data into the data warehouse. Source files include tables, delimited flat files, XML files and Sales force data.
  • Extensively used stages like Aggregator, Joiner, Transformation, Lookup, SK generator, Merge, Change Capture, Column Export/Import, Sequential files, File sets, lookup sets, Datasets, DB Connectors, XML & Pivot .
  • Improved and enhanced various jobs inside different cycles by creating Reusable & Common jobs technique.
  • Added appropriate dependencies at job level & batch process level for each job and Quantitative resources for each database/resource pools at scheduling tool to avoid deadlocks, timeout and connection issues.
  • Integrating with the data sources (like Member data and products from various systems). Comprehensively used DataStage for loading the historical data from various tables for different Line of Business
  • Managed the authenticity of UNIX components by Checking-in & Checking-out code from StarTeam/RTC , a code versioning tool.
  • Prepared Unix Shell Scripts for scheduling the jobs using Control-M.
  • Created Wisdom solution, ETL overview & Code walk through documents .
  • Actively participated in discussions and implemented Error Handling process

We'd love your feedback!