We provide IT Staff Augmentation Services!

Etl Lead, Sr.technical Analyst & Sr. Datastage Developer Resume

2.00/5 (Submit Your Rating)

Houston, TX

Hire Now

SUMMARY:

  • Around 9+ years of experience in IT industry in Data Warehouse using Oracle, Unix and Ascential Datastage in development, testing and production and Data Migration activities
  • Currently working as a Sr. Technical Analyst at Tech Mahindra, Houston
  • 5+ years of Experience on Communicating with users/ client for gathering user requirements, preparation BRD, FSD etc. and assigning activities to the team members to meet the deadlines. Worked extensively in onsite/offshore model.
  • Working Experience and good knowledge in Data warehousing (Datastage). Oracle 9i, SQL Server 2005, Server 2005 VAX - VMS, Unix
  • Worked with DataStage Server and Parallel Jobs of Ascential Data Stage (7.5.1);IBM WebSphere 8.1 and 8.7 create the jobs for extraction, transformation to complete the entire ETL process.
  • Performs the Datastage Administration activities like start/stop datastage server; exporting/importing jobs; creating new users; creating new projects ; restricting access to projects i.e Protected projects; scheduling jobs using datastage
  • 5+ years of Experience in preparing Test Plan, creating Test Scenarios, and Test cases. Support to the QA / UAT team in the functional testing
  • Excellent knowledge and experience in data warehouse development life cycle, dimensional modeling, DW concepts including star schema, facts, dimensions, SCD, staging area, repository management and administration,
  • Developed simple & complex data stage jobs to load Dimension Tables.
  • Communicating with users/ client for gathering user requirements and assigning activities to the team members to meet the deadlines. Worked extensively in onsite/offshore model.
  • Experience on Mapping documents preparation.
  • Experience in using various Server stages like Aggregator, Filter, Merge, Hash, Sort using Datastage.
  • Experience with Parallel Extender for Parallel Processing to improve job performance while working with bulk data sources.
  • Extensively experience in supporting Production Environments on handling and resolving the production issues, Job monitoring, Emergency code fix, and worked on Enhancement of existing system.
  • Comprehensive Knowledge of RDBMS.
  • Sound conceptual knowledge of different Software Development Lifecycle models and processes.
  • Dynamics, Self-motivator, fast learner and a Team player with good work ethics
  • Excellent interpersonal skills coupled with the ability to adapt quickly and understand new technologies.

TECHNICAL SKILLS:

Data Warehousing: IBM WebSphere DataStage 7.5/8.1/8.7

Databases: Microsoft SQL Server 2000/2005/2008, Oracle 10g/9i/8.x/7.x

Operating Systems: MS Windows XP, 98, Windows NT/2000, HP-UX

Languages: PL/ SQL, SQL* Plus 8, UNIX Shell Script

Tools: & Utilities: SQL* Plus 8, Erwin 3.5/4.0/4.1/7.1, Toad for Oracle V8.6, Mercury Quality Center 9.2, Autosys, CronTab, MS Visio 2003/2007, MS Office Project Standard 2003/2007,ITSM tool

PROFESSIONAL EXPERIENCE:

Confidential, Houston TX

ETL Lead, Sr.Technical Analyst & Sr. Datastage Developer

Responsibilities:

  • Understanding the existing system, business by organizing user meeting.
  • Preparation of Functional and Technical Specification by understanding the System
  • Preparing the mapping document.
  • Using the Using Data stage Client tools to convert data received from Source flat files and CSV to SQL server 2005
  • ETL Logic preparation.
  • Assigning task to off-shore
  • Validating the projects under development, staging and production.
  • Working with Tech team for all the DB synchronization, Credential for team mates and creating all the relevant BR (Business Request)
  • Involved in the Peer Review of every Data Stage job in the project.
  • Led the Design review sessions with Clients.
  • Doing the regression testing for all the Datastage job
  • Preparing and reviewing all the Project artifacts.
  • Creating, tracking and Documenting the Change request through ITSM tool.
  • Performing impact analysis for all business changes.
  • Creating the System Test scenario and script for Integration testing.
  • Assisting user for UAT testing.

Confidential

ETL Developer

Responsibilities:

  • Understand the existing Application
  • Requirement analysis
  • Find out the Gaps between New and Existing Datamodel
  • Code Review
  • Adhere to GSK Standards and quality processes

Confidential

Team Member

Responsibilities:

  • As a team member, was responsible for
  • Requirement analysis
  • Code Review
  • FTP files from Confidential, RIMS, ILIAD
  • Adhere to sessions (client telecons) Cognizant Standards and quality processes
  • Participated in Reverse KT

Confidential

 ETL Lead, Data Modeler

Responsibilities:

  • Requirement analysis
  • Design and Code Review
  • Migrate Sybase to Oracle
  • Adhere to Cognizant Standards and quality processes

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship