Data warehouse Resume

SUMMARY:

7 years of Experience in software systems Development client/server Business systems with hands - on technology experience in medium and large sized organizations in Data warehouse, ETL Ab Initio, and database administration, database design, performance tuning, UNIX/Linux.
Extensively worked in creating Data marts using Ab Initio GDE. Designed and built logical and physical models into catalogues and universes for end-user and management reporting needs.
Experience in the different Source/ Target Systems like Flat files, Multi-file systems (MFS), Multiple files (Batch of files), Ab initio queues (Continuous flow Graphs), and Relational Database systems (RDBMS) -Oracle, DB2, Teradata.
Expertise in all components in the GDE of Ab Initio for creating, executing, testing, updating and maintaining graphs in Ab Initio and experience with Ab Initio Co-operating System in application tuning and debugging strategies.
Experienced in Data Modeling using Erwin in Client/Server and Distributed applications development.
Knowledge in developing test plans, test cases, bug tracking as well as execution of manual and automated tests.
Developed heavily parallel CPU bound ETL process jobs using Ab-Initio in dynamic, high-volume environment. Designed and deployed well-tuned Ab Initio graphs for ODS and DSS instances using both Linux and UNIX environments.
Hands on experience in end-to-end of Data warehousing ETL routines, which includes developing Ab Initio graphs, stress testing, and data quality process.
Designed and deployed well-tuned Ab Initio graphs (Generic and Custom) for Unix environment.
Experienced in developing UNIX shell wrapper scripts to run Ab Initio graphs. Practical experience with working on multiple environments like production, development, testing.
Thorough understanding of the issues involved in mappings, development and integration of a software product.
Usage of Ab-Initio EME for dependency/impact analysis and configuration management. Using the same for creating project builds (TAR files), migrating them to testing and production environment.
Worked with Wrapper scripting with UNIX Shell programming, Scheduling of Ab initio jobs with AutoSys and BMC Control-M.
Strong working experience in planning and carrying out Oracle PL/SQL system upgrade initiatives, Data Warehousing, MPP and Large-Scale Database Management.
Well versed with various Ab Initio components such as Round Robin, Join, Rollup, Partition by key, gather, merge, interleave, Dedup sorted, Scan, Validate, FTP.
Knowledge in working with Data Profiler, BRE, and rules technologies.
Strong knowledge of Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema. Strong experience with Microsoft Visio to represent Flow-Diagrams, Data Model, Process Architecture and Job dependencies and hierarchies.
Ability to meet deadlines and handle pressure in coordinating multiple tasks in work/project environment.

TECHNICAL SKILLS:

Data Modeling Star: Schema Modeling, Snowflakes Modeling, Erwin

RDBMS: Teradata, Oracle, MS SQL Server, DB2

Programming: UNIX Shell Scripting, Korn Shell, SQL, SQL*Plus, PL/SQL

Operating Systems: Windows, UNIX

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship