Data Warehouse Developer Resume
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
