We provide IT Staff Augmentation Services!

Etl Designer/sr Developer Resume

Durham, NC

SUMMARY

  • About 11 years of sound experience of technical and managerial activities which involves several business domains: Banking, Telecom, Logistic and Health Insurance industry.
  • Currently working with “ Confidential Inc.” as ETL Designer/Sr Developer at Durham, NC.
  • Have experience handling a team of 20+ resources. Experience in managing an onsite offshore team.
  • 11 years of experience in data warehouse space, skilled in multiple of the disciplines of data warehouse such as Data Modeling, ETL Analyst/Designer, data management and BI reporting analyst in various development projects.
  • Expertise in Ab Initio Design, Configuration experience in Ab Initio ETL, Data Mapping, Transformation and Loading in complex and high - volume environment and data processing at Terabytes level.
  • Expertise in designing solutions around AbInitio, with advanced skills in high performance and parallelism in AbInitio.
  • Good experience in understanding business requirements and translating these to schema requirements.
  • Strong UNIX, korn shell scripting experience.
  • Strong Oracle, Teradata database knowledge
  • Experience in full software development life cycle of development projects.
  • Hands on in agile development.
  • Good interpersonal, communication, team handling and documentation skills

TECHNICAL SKILLS

Hardware Platform and OS: Windows, UNIX

Tools: / Software: Ms Office, Abinitio, Toad, Mercury Quality Center, Teradata SQL Assistant

Languages: SQL, PL/SQL, Unix shell scripting

Database: Oracle, Teradata, DB2

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

ETL Designer/Sr developer

Responsibilities:

  • Involved in analyzing the requirements and mapping the requirements into ETL design document
  • Identification of Impacts based on the new requirement in the existing system and provide effort estimates for the change.
  • Create High level design document, ETL mappings to load data warehouse table
  • Provide effort estimation and capacity planning.
  • Develop Abinitio graphs, unix scripts, SQL queries for extraction, transformation and loading of data in Data warehouse tables in Teradata
  • Involved in code review for the quality of the deliverables.
  • Involved in Unit testing and System Integration testing. Coordinated in preparing Test Environment and Test Data.
  • Involved in creating Test Plan and Test scripts document.
  • Coordinated User Acceptance Testing. Investigated and resolved defects raised by Business Users.
  • Involved in tracking defects and maintaining defect logs.
  • Involved in migration and deploying of code in QA and UAT env.
  • Involved in creation Prod Implementation plan, and coordinating the implementation in Prod.
  • Ensure all relevant documents are available and uploaded in SharePoint link
  • Tracking and monitoring work status to ensure timelines
  • Attend and Facilitate checkpoint / status meetings.
  • Onsite-offshore coordination
  • Coordination with Business Users.

Confidential

ETL designer

Responsibilities:

  • Involved in analyzing the requirements and mapping the requirements into High level document and Detail design document.
  • Create High level design document, ETL mappings to load data warehouse table
  • Provide effort estimation and capacity planning.
  • Develop Abinitio graphs, unix scripts, SQL queries for extraction, transformation and loading of data in Data warehouse tables in Teradata
  • Involved in internal and external code review for the quality of the deliverables.
  • Involved in Unit testing and System Integration testing. Coordinated in preparing Test Environment and Test Data.
  • Involved in creating Test Plan and Test scripts document.
  • Coordinated User Acceptance Testing. Investigated and resolved defects raised by Business Users.
  • Involved in tracking defects and maintaining defect logs.
  • Involved in migration and deploying of code in QA and UAT env.
  • Involved in creation Prod Implementation plan, and coordinating the implementation in Prod.
  • Ensure all relevant documents are available and uploaded in SharePoint link
  • Tracking and monitoring work status to ensure timelines
  • Attend and Facilitate checkpoint / status meetings.
  • Onsite-offshore coordination
  • Coordination with Business Users.

Confidential

Abinitio ETL developer

Responsibilities:

  • Involved in analyzing the requirements and creating the Detail design document.
  • Develop Abinitio graphs, unix scripts, SQL queries for extraction, transformation and loading of data in Data warehouse tables in Teradata
  • Involved in internal and external code review for the quality of the deliverables.
  • Involved in Unit testing and System Integration testing. Coordinated in preparing Test Environment and Test Data.
  • Involved in creating Test Plan and Test scripts document.
  • Coordinated User Acceptance Testing. Investigated and resolved defects raised by Business Users.
  • Involved in tracking defects and maintaining defect logs.
  • Checking in and tagging of Abinitio graphs/scripts.
  • Creating Packages for the set of artifacts to migrate from one environment to other environment
  • Involved in migration and deployment of code in production. Involve in creation of Implementation plan.
  • Tracking and monitoring work status to ensure timelines
  • Attend and Facilitate checkpoint / status meetings.
  • Onsite-offshore coordination

Confidential

ETL developer

Responsibilities:

  • Involved in analyzing the business requirements and creating the Detail design document.
  • Involve in developing Abinitio graphs, PL/SQL programs based on design document, unix scripts to run the graph’s deployed Unix scripts, SQL queries for extraction and loading of data in Data warehouse tables
  • Involved in Unit testing and System Integration testing. Create Test Plan and Test scripts document.
  • Involve in checking in and tagging of Abinitio graphs/Scripts
  • Creating Packages for the set of artifacts to migrate from one environment to other environment
  • Create prod implementation plan, support and coordinate prod implementation.
  • Involved in internal code review for the quality of the deliverables.
  • Ensure all relevant documents are available and uploaded in SharePoint link.

Confidential

ETL developer

Responsibilities:

  • Analyzing the Business Requirements and System Specifications.
  • Developing SQL queries, PL/SQL codes according to design document.
  • Preparing unit test plan/test cases, Conduct unit testing.
  • Involve in verifying the code standard as per the code review checklist.
  • Coordinating with the testing team in Test Environment preparation, System Integration testing, Regression testing
  • Review Testing documents including Test Specification, Test Plan, Test results
  • Investigating and resolving the problem logged by testing team.
  • Migration and deployment of codes into Production Environment.
  • Create prod implementation plan, support and coordinate prod implementation.

Hire Now