Sr. ETL Specialist Resume

SUMMARY

Sr. ETL Specialist with 10+ years of experience in Software Development Life Cycle (SDLC), Business Intelligence & Data Warehousing Technology for Biopharmaceutical, Travel & Transportation, Media Entertainment & Broadcasting, Manufacturing and Telecom & Communications Institutions.
Expertise in leading ETL implementations including requirement gathering, designing, coding & reviews. Proficient in actively coordinating work with teams both onshore and offshore (India & Philippines). Also efficient in developing data models, testing methodologies such as functional, regression, integration and performance testing.
10+ years of experience in the Information Technology industry with strong knowledge in data warehousing functionalities.
Proven expertise in Data Warehousing applications, responsible for Extracting, cleansing, Transformation and loading of the data from multiple feeds and sources into Data Warehouse.
Strong ETL experience using Informatica Power Center (Repository manager, Designer, Workflow manager, Workflow monitor), Mapplets and Transformations.
Experience with Informatica PowerExchange to pull data from Mainframe, AS400 systems
Experience with Informatica MQ Queue connectors to extract data for real time data processing
Experience with Informatica DQ for data cleansing and calibration
Excellent understanding of ETL concepts, standards and best practices
Excellent inInformaticaPower Center and SQL/PLSQL for ETL cycle development.
Experience in Effort estimation, resource allocation and delivery management and Involved in Business Analysis, collecting User and System Requirements, identification of technical risks, and dependencies.
Expertise with data warehousing techniques and proficiency in building ETL Loads to load star schema, snow flake models as well as 3N Form for cases such as: slowly changing dimensions, late arriving facts, late arriving dimensions, surrogate keys
Expertise in creating Business Requirements, Design, Technical, Pre & Post production, Pre & Post Installation and Upgrading documents for ETL and BI Applications.
Experience in Unit, System and Integrate Testing of different process in Data warehouse.
Experience on Business Requirements Analysis, Application Design, development, testing, implementation and maintenance of client/server Data Warehouse systems in Media & Entertainment, Manufacturing, Telecom & Communications, Travel & Transportation industries.
3+ years of Dimensional and Data Modeling using Star & snow Flake schemas. Experience with Fact and Dimension Tables.
9+ Years of Database Experience using Teradata, Oracle, SQL Server, MS Access
Hands on Working knowledge of PL/SQL - Writing Stored Procedures, Packages, Functions and Triggers.
8+ years of UNIX shell scripting experience.
Experience in working with Windows Powershell, Batch scripting
Experience in conducting Informatica Trainings
Participated in business and technical design sessions with DBAs, developers and Extensive experience in business analysis, gap analysis, cost/benefit analysis, testing, development of functional specifications and project planning.
Experience in Oracle to Teradata Migrations, BTEQ Scripting, SQL Assistant etc
Lead the warehouse design and integration effort, including data sourcing and transformation.
Highly motivated and adoptive with the ability to grasp things quickly with excellent interpersonal, technical and communication skills.
Ability to work effectively and efficiently in a team and individually.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 5.1/6.2/7.1.2/8.1.1/8.6.1/9.1/9.5, Informatica On Demand, Informatica Power Exchange, Informatica Data Quality

Databases: Teradata 12.0/13.10/14.10/15.0, Oracle 8i/9i/10g/11g, SQL Server 7.0/2000/2005/2008 R2, MS Access 2007

Languages: SQL, PL/SQL, TTU Loads, BTEQ Loads, Stored Procs, Unix Shell Scripting, Windows PowerShell Scripting, Windows Batch Scripting

Database Tools: Teradata SQL Assistant, PL SQL Developer 7.1,TOAD 8.0, SQL Server 2005, 2000

Modeling Tools: ER win 4.5/4.0, Microsoft Visio 2013

BI Tools: Business Objects 6.5/XI R2, Cognos 7 Impromptu, PowerPlay, Vizualizer, Cognos 8 Report Studio, Query Studio, OBIEE 10x

Operating Systems: MS-DOS, Window XP/2000/NT, Window Vista, Windows 7, Windows 8, UNIX, LINUX

Schedulers: Control - M, IBM Tivoli

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Specialist

Responsibilities:

Provide high level oversight required for the day-to-day ETL Operation
Informatica Administration
Data Analysis, Data Validation
Informatica Administration
Developed & Tested ETL mappings on a need basis.
Engaged in the vetting process for the Dollar-Thrify Integration data
Give direction to ETL Prod Support and Dev Team on ongoing support / tasks

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship