Sr. ETL/BI Architect & Developer Resume

TECHNICAL SKILLS:

Informatica Power Centre(8.x,7.x, 6.x): Repository Manager, Repository Server, Administration Console, Designer, Workflow Manager, Workflow Monitor

OWB(11g,10g,9i): Repository Assistant, Repository Browser, Design Centre, Process Flows

Datastage(8.5,8.0,7.5): Datastage Administrator, Datastage Designer, DataStage Director Microsoft SSIS, Talend ETL, Pentaho ETL, Sybase ETL, BO Data Integrator, ODI Data Quality & Data Profiling

IBM: Information Server, Information Analyzer, QualityStage

Informatica: Informatica Data Profiler, Informatica Data Quality

Talend: Talend Data Profiler

BI Dashboard & Reporting Tools: Siebel Analytics(7.x), OBIEE(10g) Physical Data Model layer, Business Model Layer & Presentation Layer, Admin Tool, Analystics Web, RPD, Ibots

MicroStrategy(9.0,8.1, 8.0.2): MicroStrategy Desktop/Web, Intelligence Server, Administrator, Narrowcast Server, Object Manager, Office

PROFESSIONAL EXPERIENCE:

Sr. ETL/BI Architect & Developer

Confidential

Responsibilities:

Data Warehouse & MDM Development: Proven track record in planning, building, managing and deploying successful large - scale Data Warehouse, MDM, and decision support systems. Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
QA and SLA’s: Deep experience in peer review, unit testing, ETL test plan, ETL performance test plan, bug fixing, and performing error free, on time and within budget delivery of projects.
Domains Expertise: Deep experience in data warehouse, MDM and BI projects implementation with Healthcare, Financial, Government and Retail domains.
Project Management & Estimation: Proven track record in managing Data Warehouse and BI technical teams, assisting the project manager with task planning, estimation and conducting project co-ordination activities. Well versed with SDLC life cycle (waterfall and agile methodologies).
Requirement Gathering: Deep experience in Understanding business processes and gathering requirements from subject matter experts.
ETL Development: Expertise in creating ETL routines and mappings using Informatica, Datastage, OWB, ODI, SSIS, Talend and Pentaho to move data from multiple sources into targets. Extensively worked on the ETL mappings, analysis and documentation. Deep experience in creating fact, dimension, staging, ODS and other database objects like views, stored procedure, function, indexes, constraints.
BI Development: Expertise in designing and deploying BI reports and dashboards using OBIEE, Microstrategy and Business Objects.
Database Development: Expertise in database development and designing using Oracle, Sql-Server, Sybase ASE, Sybase IQ, Netezza and Db2.
Data Modeling: Deep experience in Data Modeling, Dimensional modeling using Erwin, MS-Visio and Power Designer.
Data Profiling and Data Quality: Deep experience in data profiling, Data Architecture Policies, Standards, Governance and data cleansing with IBM Information Analyzer, IBM Quality Stage and Informatica data quality.
Database Integration: Expertise at enterprise database Integration and management among MS SQL Server, Oracle, MS Access, Sybase ASE and Sybase IQ.
Administration Tasks: Deep experience in performing ETL, BI and Database administration tasks. Involved in tool installations, configuration, adding users, managing roles, assigning privileges, memory management, storage estimation, tuning of ETL, BI and database routines.
Best Practices & COE: Deep experience in developing ETL, BI and Database development best practices and developing center of excellence for Informatica, IBM Datastage, OBIEE and Microstrategy.
and Instructing: Expertise in guiding,, assisting the team members on technical issues and new technologies.
Documentations: Deep experience in developing physical design, logical design, source to target, data profiling, bus matrix documentation to help in standardization.
Methodologies: Expertise in implementing Ralph Kimball(Top Down), Bill Inmon(Bottom Up) and Agile methodologies, and also well versed with Dimensional Modeling (Star, Snow Flake and Galaxy Schemas) to build the Data warehouse.
SCD & CDC: Specialty expertise in implementing and deploying complex ETL flows to track change records with SCD (type 1,2 and 3), database CDC routines and Replication Server.
Conversion Programming & Bulk Loading: Deep experience in loading data from flat files with SQL*Loader, Import Export utilities and loading data with bulk loader and BCP utilities.
Strong business and technical vision with effective people skills to allow close work with senior management. Innovative, creative, problem solver and result oriented, with an aptitude for learning and can maximize resources while possessing a sense of urgency.
Possess excellent communication, analytical & interpersonal skills.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship