We provide IT Staff Augmentation Services!

Etl /teradata Sr. Developer Resume

SUMMARY

  • Accomplished and Enthusiastic software professional with extensive experience in challenging roles as ETL Sr. Developer.
  • Successfully delivered data integration and data migration projects.
  • Strengths are to work passionately towards a collective team goal, maintain discipline, innovate towards new solutions and radiate positivity and work dedicatedly in large programs to meet tight deadlines.

Core competencies:

  • Datastage designer 8.x/9.x/11.x
  • Datastage director 8.x/9.x/11.x
  • Microsoft SQL Server
  • SQL and Load Utilities (BTEQ/MLOAD)
  • Windows/Unix
  • Linux Shell Scripting
  • IBM - Tivoli Workload Scheduler
  • Agile Scrum/Sprint
  • SDLC
  • SVN - GIT Lab
  • BMC Remedy
  • JIRA

PROFESSIONAL EXPERIENCE

Confidential

ETL /Teradata Sr. Developer

Responsibilities:

  • Implemented Data Authentication for GDPR for American Airlines.
  • Involved in Requirements gathering phase as ETL Analyst.
  • Prepare the ETL Design and Involved in understanding and gathering customer custom business processes.
  • Helping the Team to debug the issues.
  • Responsible for analysis, providing the solutions and implementing the solutions as per Compliance and Standards defined.
  • Experience in Design and Development of ETL methodology for supporting Data Migration, data transformations & processing in a corporate wide ETL Solution using Datastage v11.x and Confidential 16.0/14.0.
  • UsedTeradata utilities FAST LOAD, MULTI LOADto load data.
  • Wrote, tested and implemented Confidential Fast load, Multiload and BTEQ scripts, DML and DDL.
  • Worked on large data sets by performing extraction and loading.
  • Providing the Estimates and assigning the workaround and update the status to stake holders.
  • Support the System Testing Team while ST and UAT and provided the required clarifications and solutions for smooth Production Roll-out.
  • Provided the analysis for many Bugs and flaws and fixed it within less time to make sure it won't impact the large group of customers.
  • Provided the Guidance and support to the team while doing the analysis and in bug fixing.
  • Reviewing the Bug fix and Unit Testing and UTR’s.
  • Having Discussion for the Solutions, Fixes and impact analysis with Team and Onsite Counterpart.
  • Worked on developing ETL mappings and workflows.
  • Configured pre- session and post- session tasks involving in calling of shell scripts.
  • Mappings created using various simple and complex transformations.
  • Working on multiple and alternative solutions to reduce the efforts and time to complete the deliverables on/ before time.
  • Working on Automation of the process and providing the support and guidance to the team.
  • End to end project implementation and sanity checks.

Confidential

Datastage Developer

Responsibilities:

  • Designed and Developed ETL Processes using datastage for eligibility check and claims for health insurance firm.
  • Data Extraction, aggregations and complex transformations.
  • Unit testing and ST and helped the client with the UAT.
  • End to end code implementation.
  • Involved in code review.
  • Performance tuning of datastage jobs.
  • Data extraction from the Microsoft SQL Server, transformed using datastage 11.x and loaded into flat file which is used by various US insurance clients.
  • Adhere to HIPA compliance.

Confidential

Data specialist

Responsibilities:

  • Worked in Confidential, Telecom, life insurance and logistics domain.
  • Lead the offshore team of 3 datastage developers.
  • Worked on parallel and sequential datastage jobs v8.x/9.x
  • Worked on data integration, data migration and datawarehousing.
  • Performed development, Unit Testing, ST.
  • Created Technical design document, Unit test cases, HLD, LLD, Prod deployment checklist.
  • Worked closer with client on high priority bug fixes.
  • Provided RCA of code anomaly.
  • Automated the common test cases used.
  • Checked and validated the process flow and data flow from the source till the target loads.
  • Involved in technical training for new project members and cross technical training of datastage to non-datastage resources.
  • Prime for providing estimation for code delivery.
  • Prime for status update of the progress to the client.
  • Provided the Post Implementation Validation for the code when the code is migrated to UAT
  • Coordinated with QA team for closure of defects and sign off
  • Prime for task assignment to the offshore DS developers.

Hire Now