ETL Developer Resume

SUMMARY

5+ years of IT experience in Data Warehousing projects involving in Requirement gathering, Analysis, Design, Data Modeling, Data Architecture, Development, Integration, Implementation, Maintenance, Testing and Production Support of Applications.
Performance Engineering of DB SQLs and ETLs.
Strong skills in IBM - DataStage, SQL Programming, IBM DB2, Oracle PL/SQL, Debugging, Performance tuning and Shell Scripting.
Created a Detailed design technical artifacts with
Data Flow Diagrams (DFDs), Program architecture designs and Data Models Design.
ETL/ELT Jobs, ETL Designs, SQLs and reference table designs.
RTM, Data Loading Methodologies, Post Implementation support
Rich Experience in Retail, Sales, Supply Chain and Banking Domains.
Executed multiple end to end Enterprise data warehousing projects.
Windows, Linux, and Mac OS configuration, administration, and security management
Configuring virtualized hosts, networks, and sandboxed environments
Proficient in Programming Languages - C, C++

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Technology: DataStage 11.5, UNIX Shell Scripting, SQL, Control M

Involved in design, analysis, development of High-level Design, Detailed level Design and data integration mapping.
Designed ETL jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts using DataStage Tools which includes error processing, reprocessing logic, count match logic, restart ability logic.
Worked extensively on different types of stages like Sequential file, lookup, Aggregator, Transformer, Join, Pivot, Sort, Filter, Enterprise/API for developing jobs.
Designed Shared container with RCP Technology for Populating Stage tables used in Phase II.
Designed Job Sequences and scheduling jobs based on dependencies.
Created reusable, wrapper scripts and count scripts for invoking DataStage jobs.

ETL Developer

Confidential, MN

Technology: Oracle, MS-SQL Server, DataStage, UNIX Shell scripting and Control-M

Responsibilities:

Analyze and understand requirements from Business teams.
Accountable for Architect related deliverables to ensure all project goals are met within the project time lines.
Designed Data Architecture, Data Modeling and ETL Architecture/Design.
Identified columns for compression in tables for efficient usage of disk space.
Performance Engineering: Cases where performance improved by more TEMPthan 50%.
Created different single and multi-table JOIN indexes for aggregate tables and reporting queries.
Changed data load methodology of dimensional tables, which where been used in Oracle Join Indexes.
Revisited Indexing strategy and collection of stats.
Created detail step-by-step documents and executed the same in Production to load data into different tables defined with Join Indexes (like dropping JIs, loading data into the tables and then re-creating the JIs).
Validating DDL statements to ensure it meets standards (Like Names, Indexing, Compression etc.).
Worked on Parallel Jobs using Various Stages like Sequential File, Dataset, Lookup, Join, Aggregator, Remove Duplicate, Modify, XML, Filter, Funnel, Copy, Surrogate Key Generator, Sort, Store Procedure Stage, Transformer, MS-SQLDB2/Oracle Connector stages.
Provide daily status update to onshore/offshore team and coordinate work between onshore and offshore.
Designing solutions (for Data Warehouse system) as per requirements and creating artifacts (HLD/LLD/Testing Scenarios) with program architecture (with DB SQLs and mapping designs) and created a detail test plan.
Develop STMs (Source to Target Mapping) documents with business transformation logic.
Involved in Development/Testing and Implementation phases.
Post production implementation support and work with business for program enhancements.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship