ETL Developer Resume Dallas, Texas - Hire IT People

SUMMARY

Good Data Warehousing experience in data analysis, development and implementing software solutions in various business applications using ETL tool Informatica PowerCenter
Experience in Database Design, Entity - Relationship modeling, Dimensional modeling like Star-schema, Snowflake-schema, Fact and Dimension tables
Very good experience in various types of Data Analysis
Closely worked with business and BI teams to provide best Business Intelligence reporting solutions
Extensively worked on Data Integration with various components of the Informatica PowerCenter - Power Center Designer (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer), Repository Manager, Workflow Manager, and Workflow Monitor to create mappings for the extraction of data from various source systems
Experience in implementing complex business rules by creating Informatica re-usable transformations, and robust mappings/mapplets using different transformations like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure, Normalizer etc.
Proficient in full life cycle development of Data Warehousing, ETL strategies, reporting and hands on experience in Performance Tuning of sources, targets, transformations, mappings, and sessions using Database Tuning, Partitioning, Index Usage, Aggregate Tables, Session partitioning, Load strategies, commit intervals and transformation tuning
Extensive experience in integrating data from various Heterogeneous sources like Relational database (Oracle, SQL Server), Flat Files (Fixed Width and Delimited), XML Files and Excel files into Data Warehouse and Data Mart
Worked with Slowly Changing Dimensions type 1 and type 2
Experience in Oracle PL/SQL Programming (Stored procedures, Triggers, Functions, Packages)
Good experience in documenting process flows for better maintenance and analyzing the data flow
Independent yet team oriented with excellent analytical, problem solving, multi-tasking, oral and written communication skills

TECHNICAL SKILLS

ETL TECHNOLOGY: Informatica Power Center 10.2

DATA WAREHOUSE: Multidimensional Model Design, Star Schema Development

DATA MODELLING: Star-Schema Modeling, Snowflake Modeling

DATABASES: Oracle 19C/12.2, MS SQL Server7.0/2000, DB2(iSeries/AS400), MS Access

PROGRAMMING: SQL, PL/SQL,UNIX Scripting

OPERATING SYSTEMS: Windows, MAC, UNIX, MS-DOS

OTHER TOOLS: Automic/UC4, Start, Ticket Plus, Service Now/Dash, Toad, SQL Developer, SQL Server 2014 Management Studio

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Texas

ETL Developer

Responsibilities:

Worked as a member of the Integration Hub Team where I was responsible for design, development and testing Informatica and database codes
Analyzed and communicated ETL development issues, including problems with data integrity, data design, and functional and technical issues
Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables
Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions, or system which led to better session performance
Used Informatica Power Center 10.2 for migrating data from various OLTP servers/databases to the data mart
Created stored procedures for generating the data warehouse cycle dates and to drop, re-create the indexes
Worked with various Active and Passive transformations like Source Qualifier, Sorter, Aggregator, Filter, Union, and Router Transformations, Sequence Generator and Update Strategy Transformations
Handled versioning and dependencies in Informatica
Worked on designing the technical documents
Responsible for Codes Review, unit testing and process Documentation Review
Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements
In Automic scheduler created informatica jobs using PMCMD command
Part of Production Support Team and Monitored systems and processes to ensure seamless loading of data in time
Extracting and transforming data from various relational databases, ERP systems and flat files to the data warehouse
Analyzed Business and Technical requirements and designed enhanced ETL Processes to meet that requirement
Hands-on Experience in working with Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets to extract, transform and load data
Developed Test Cases according to Business and Technical Requirements and prepared SQL scripts to test data for both Unit testing and UAT testing
Developed schedules to automate the update processes and Informatica sessions and batches
Resolving technical and design issues
Discussed with customers and technical support on Data Migration and Data warehousing
Deployment of ETL and databases codes across environments

Environment: Informatica Power Center 10.2, SQL Server 2005/2000 Oracle 11g, Automic/UC4 schedule, Start, Ticket Plus, ServiceNow/Dash

We provide IT Staff Augmentation Services!

Etl Developer Resume

Dallas, TexaS

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship