Data Architect / Sr. ETL Developer Resume

SUMMARY

He is an Informatica, Siebel and Salesforce Certified Developer with extensive hands on experience with data migration / data integration and reporting.
He has 20+ years’ experience in System Implementation in various industries which include: telecommunications, sales, marketing, banking, insurance, manufacturing, distribution and automotive.
He has an in - depth background for process re-engineering, designing, developing and implementing enterprise wide applications.
He has worked in several full cycle technical development projects that include requirements of gathering, development, testing, and deployment.
As he designed and developed Siebel EIM process to import data for various Siebel base tables in different Siebel Applications using ETL tools, he also has a solid understanding of Siebel Architecture and Siebel Data Model and Migration Methodologies. He developed design flows, converted data from legacy systems, application configurations, and developed workflows, scripts, and batch files that automate customer transactions.
He is able to coordinate and communicate with project team. He is able to work independently and as part of team.
He has excellent analytical/problem-solving skills, self-initiative and fast to learn new skills/technologies, resourceful, committed, and smart-worker.
He can work under pressure and complete tasks with high-quality deliverables ahead of time and budget.

TECHNICAL SKILLS

Databases/OS: Oracle, MS SQL Server 2012/2010, IBM DB2 UDB, Sybase, CA-Ingres, Windows, Sun Solaris, and DOS.

ETL / Applications: Informatica 8.6.1 / 9.5.x, IBM WebSphere DataStage Client and Director 8.5, MS SQL Server Integration Services (SSIS),, MS DTS Package, Siebel Public Sector, Siebel Call Center, Siebel Sales and Marketing, Siebel eCommunications, Siebel Finance, Siebel eMedia, Siebel Tools, Microsoft Visual Basic, Visio, MS Office, IBM Rational ClearQuest, IBM Rational Portfolio Manager, MS Visual SourceSafe.

Training: IBM Websphere DataStage Enterprise Edition, MQ Series Administration, Siebel EAI, OBIEE 10g Dashboard Report Application, Salesforce, C/C++ Language, Mastering Microsoft Visual Basic, Fulcrum, Cognos, Siebel 2000 / 98, Informatica Data Transformation, Informatica Data Exchange.

PROFESSIONAL EXPERIENCE

Confidential

Data Architect / Sr. ETL Developer

Responsibilities:

Redesigned the initial and incremental data loads of 18 Salesforce Objects into reporting database tables that increased the efficiency from days to 4 hours for millions of records.
Initiated the efforts in differentiating the efficiency between Informatica PowerCenter and Informatica Cloud to SQL Server.
Created reporting and control table DDL scripts, ETL mappings, sessions and workflows.
Fine-tuned the performance of the Informatica sessions to optimize the Salesforce data load to SQL Server.
Led the code review of the developed Informatica ETL mappings, sessions and workflows with the Sutter team.
Published the Promotional Plan from environment to environment.

Confidential

Data Architect / Sr. ETL Developer

Responsibilities:

Gathered Salesforce and EPIC integration requirements for Inbound and Outbound processes.
Took ownership in the creation and updates of the Data Mapping Document for Salesforce and EPIC integration.
Designed, developed and unit tested the ETL Mappings and Staging Tables for the integration process.
Created staging and control table DDL Scripts, ETL mappings, sessions and workflows.
Created unit and integration test cases and participated on System Integration Test activities.
Led the code review of the developed Informatica ETL mappings, sessions and workflows with the Sutter team.
Published the Promotional Plan from environment to environment.

Confidential

Sr. ETL Developer

Responsibilities:

Involved in requirement specifications, analysis, design, development, & testing of application.
Designed and developed the staging database and loaded from source to staging and from staging to the Destination tables applying different transformations.
Responsible in creating and maintaining the data mapping document for the Promotions and Customers project.
Developed queries and ETL mappings to load the data into warehouse.
Used Toad DataPoint for Data Profiling of legacy tables.
Implemented Slowly Changing Dimension (SCD) type 2 to maintain Historical Data.
Created deployment groups and promote ETL mappings / Workflows from Development to QA
Created unit test scenarios and performed code reviews and applied naming standards.
Provided assistance to testers on the developed ETL mappings and explaining the data mapping.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship