Data Warehousing Designer Resume

SUMMARY:

I have around 5 years of experience in Data Warehousing design, development, and testing. I am an experienced datastage developer having hands - on development experience in versions 8.7 and 11.5 using Waterfall as well as Agile (Scrum) Methodology. I am proficient in Oracle SQL and Unix scripting. I possess excellent communication, interpersonal and presentation skills.
Good knowledge in Datastage parallel jobs using version 8.7 and 11.5
Good knowledge of Oracle SQL, PL/SQL, and SQL tuning
Extensive experience in using transformer, aggregator, lookup, join, pivot, filter, SK, RemDup, Funnel, Copy, Peek, Dataset, Sequential File, Oracle Connector, Parameter Sets, Sort, and Change Capture stages
Experienced in using Datastage Designer, Director, Administrator, and Oracle SQL Developer tools
Experienced in using appropriate partitioning strategy in the design of jobs
Extensive experience in building sequence jobs with appropriate dependency and consideration for run optimization
Hands-on experience in data profiling such as metadata, column value analysis
Good knowledge on Data Warehousing concepts such as Facts, Dimensions, and various types of Slowly Changing Dimensions (SCD)
Experienced in all phases of SDLC such as design/development, testing, deployment, and maintenance
Working knowledge of Data Modeling that allows accurate interpretation of Data Models
Proven track of developing clear, maintainable, and efficient code using ETL best practices and standards
Experienced with the concepts of reusability, restartability/recoverability, maintainability, and performance in datastage job design and development
Working knowledge of Runbook (Operational Manual) contents
Understanding technical specifications, source-to-target mappings, development standards, and development datastage jobs
Data Profiling of source data to evaluate the actual contents, structure, and quality of data
Creating Unit Test scripts and conducting unit tests
Reconciliation of data between source and target
Supporting System Integration and User Acceptance Tests
Support deployment activities such as creation deployment notes, export and import of datastage jobs into various environments

PROFESSIONAL EXPERIENCE:

Confidential

Data Warehousing Designer

Responsibilities:

Analyzed the technical specification and the mapping document to determine the ETL design.
Profiled the source system data (in Oracle tables) to understand the data contents and the structure.
Analyzed the source and the target data models to understand the structure metadata - relationships, constraints, Primary Keys (PK), Referential Integrity/Foreign Keys, Natural Keys, and other technical fields such as Surrogate Keys, Load/Update Dates etc.
Developed datastage jobs to load transient staging tables (truncate and load daily)
Created unit test scripts
Created reconciliation scripts to ensure data was loaded into the staging tables completely and accurately. This included row count reconciliation, comparison of hash total of numerical values, and comparison of code values between source and target.
Developed jobs to load data from the staging tables to the Data Warehouse using SCD type 0 (Always insert) and SCD type 2 (maintaining history of changes) techniques.
Creation rejection datasets from Lookup, transformer, and Connector stages to identify source data inconsistency and subsequent resolution.
Participated in peer reviews of the jobs and addressed the review comments
Prepared documents describing jobs and contributed Runbook.
Developed Sequence jobs
Applied ETL best practices in the development of datastage jobs. The objectives are to achieve reusability, Restartability/recoverability, maintainability, performance optimization, and last but not the least maintaining presentability of the jobs.

Environment: Datastage 8.7/11/5, Oracle 11g, and Unix

Confidential

Data Warehousing Designer

Responsibilities:

Analyzed the technical specification and the mapping document to determine the ETL design
Profiled the data (in source sequential files) to understand the data contents and the structure
Developed datastage jobs to load transient staging tables (truncate and load daily)
Created unit test scripts
Created reconciliation scripts to ensure data was loaded into the staging tables completely and accurately. This included row count reconciliation and comparison of code values between source and target.
Developed jobs to load data from the staging tables to the Data Warehouse.
Developed Sequence jobs
Collected rejection datasets using Lookup, Transformer, and Oracle Connector stages.

Environment: Datastage 8.7 Oracle 11g, and Unix

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship