We provide IT Staff Augmentation Services!

Data Warehouse Developer Resume

3.00/5 (Submit Your Rating)

SUMMARY

  • Data warehouse consultant with expertise on Ab initio, Enterprise Meta Environment, Informatica, Shell Scripting, Oracle, Teradata and DB2.
  • 9 years of experience in Data Warehousing applications using Ab Initio and Informatica.
  • Strong knowledge of Data Warehousing concepts and Dimensional modeling.
  • Extensively used ETL methodologies for implementing data extraction, transformations and loading process usingAb Initio.
  • Very good working experience with all the Ab Initio components.
  • Extensively worked on continuous graphs and MQ series messaging.
  • Worked on Multifile systems.
  • Expert in tuning Ab Initio graphs for better performance.
  • Experience in working with various data sources like Oracle, SQL Server, and DB2 and worked on integrating data from flat files and XML files.
  • Developed mappings and workflows in Informatica to load the data from various sources into the Data warehouse.
  • Good Understanding of Software Development Life Cycle (SDLC) and Agile Methodologies.
  • Experience in developing Entity - Relationship diagrams, Logical and Physical Data Models, and the use of Data modeling tools.
  • Exposure to other ETL tools Data Stage and Talend.
  • Exposure to BI tools like Tableau and Cognos.
  • Expertise in writing complex queries, views, and stored procedures.
  • Solid experience in developing UNIX shell scripts.
  • Worked on the automation of the ETL jobsusing Control-M, Autosys and CA7.
  • Excellent analytical, problem solving and communication skills.

TECHNICAL SKILLS

ETL Tools: Ab Initio (Coop sys 3.2/2.15, GDE 3.2/1.15), Informatica 8.1 and Talend Open Studio 6.2.1

Database: Amazon Redshift, Teradata, Oracle 8i/9i/11i/12c, DB2v8 and SQL Server 2005

Operating Systems: Windows XP/2000 and UNIX/LINUX.

Programming Languages: C, C++, Java, PL/SQL

Scheduling Tools: Control-M (Enterprise Manager 7.0/Desktop Manager 7.0), Autosys And CA7

Reporting Tools: Tableau 9.2

SQL Tools: Teradata SQL Assistant, SQL Workbench

PROFESSIONAL EXPERIENCE

Confidential

Data warehouse developer

Responsibilities:

  • Understanding the Data Migration process of CARDS LOB.
  • Involved in developing drop box component.
  • Adding Drop box component to AbInitio graphs to move files to S3 bucket.
  • Performed code checker and data linage scripts before and after development.
  • Created data containers in AWS S3 using AWS console.
  • Created wrapper scripts to load data from S3 bucket to Redshift.
  • Prepared config/schema and sql files.
  • Created python script for data validation between Teradata and Redshfift.
  • Scheduling and monitoring the jobs on Control M.

Environment: Ab Initio (GDE 3.2.6.1, Co-Op sys 3.2.5.1), Teradata, AWS Redshift, Linux, Control M

Confidential

Data warehouse developer

Responsibilities:

  • Understanding the Data Migration process.
  • Prepared low level design documents.
  • Developed graphs in AbInitio to process excel files.
  • Created graphs to load data from source DB to target DB.
  • Perform data loading iteratively.
  • Validating the data and fixing the issues.

Environment: Ab Initio (GDE 3.2.2, Co-Op sys 3.1.7), Sun Solaris-UNIX, Oracle 11g

Confidential

Senior Ab Initio developer

Responsibilities:

  • Understanding the PDM (Physical Data Model) and come up with mapping documents.
  • Developed AbInitio graphs and Plans.
  • Wrote shell scripts.
  • Prepared code review documents.
  • Created Unit test cases to complete Unit testing.
  • Used Toad to verify the counts and results of the graphs.
  • Created tags for graphs/plans migration to QA.
  • Prepared CA7 jobs.

Environment: Ab Initio (GDE 3.2.2, Co-Op sys 3.1.7), Sun Solaris-UNIX, Oracle 12c and CA7

Confidential

Sr AbInitio Developer

Responsibilities:

  • Understanding the business requirements and prepare design documents.
  • Development/Enhancement of AbInitio graphs and plans.
  • Prepare XSD (XML Schema Definition).
  • Writing shell scripts.
  • Prepare code review documents.
  • Develop Unit test cases to complete Unit testing
  • Fixing the defects.
  • Creating tags for graphs/plans migration to QA.
  • Providing solutions to improve graphs performance.
  • Prepare CA7 jobs.

Environment: Ab Initio (GDE 3.1.4, Co-Op sys 3.1.7), Sun Solaris-UNIX, Oracle 11i and CA7

Confidential

Sr AbInitio Developer

Responsibilities:

  • Understanding the business requirements and prepare design documents.
  • Development of AbInitio graphs and plans.
  • Writing shell scripts.
  • Prepare code review documents.
  • Developed Unit test cases to complete Unit testing
  • Fixing the defects
  • Creating tags for graphs/plans migration to QA.
  • Providing solutions to improve graphs performance.
  • Prepare CA7 jobs.

Environment: Ab Initio (GDE 1.15, Co-Op sys 2.15), Sun Solaris-UNIX, Teradata, Oracle 11i and CA7

Confidential

Sr AbInitio Developer

Responsibilities:

  • Analyze the requirements and come up with the design document representing the same.
  • Development of new Ab Initio graphs.
  • Development of plans to define the workflow.
  • Writing shell scripts.
  • Developing wrapper scripts to run Ab Initio graphs
  • Played vital role in identifying the defects and provided concrete solutions.
  • Preparing and updating checklists, review logs, defect logs and unit test cases.
  • Involved in unit testing and UAT.
  • Review and analyze the graphs to improve performance.
  • Preparing JIL files for job scheduling in Autosys.

Environment: Ab Initio (GDE 1.15, Co-Op sys 2.15), Sun Solaris-UNIX, DB2v8, Autosys

Confidential

Developer

Responsibilities:

  • Preparing the design documents.
  • Development of Ab Initio graphs.
  • Preparing shell scripts.
  • Involved in testing.
  • Preparing and updating checklists, defect logs and unit test cases.
  • Performance tuning of graphs.
  • Scheduling the jobs in Autosys.
  • Preparing Knowledge Transition documents.

Environment: Ab Initio (GDE 1.14, Co-Op sys 2.14), Sun Solaris-UNIX, DB2v8, Autosys

Confidential

Developer

Responsibilities:

  • Involved in loading data from Source Legacy systems to staging area and then load data into target tables.
  • Used Mapping parameters while running the sessions
  • Performance tuning at mapping level and session level
  • Involved in testing.
  • Reviewing the code as per the business rules and provide specifications
  • Involved in fixing up the defects in mappings
  • Preparing test cases and reviews the test results.

Environment: Informatica Power Center 8.1, SQL Server 2005, Windows-XP

We'd love your feedback!