Sr. ETL Developer/ Consultant Resume Washington, DC - Hire IT People

SUMMARY

18+ years of strong Data Warehousing and ETL experience using Informatica PowerCenter, PowerExchange, B2B, Mappings, Mapplets, Transformations and Oracle, Teradata, DB2, Netezza, SQL Server
Extensive skills in designing and developing ETL applications for Federal Government and private sector clients in Telecommunications, Banking, Hospitality, and Medical Devices domains
Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse
Expertise in tuning existing mappings, identifying and resolving performance bottlenecks at source, target, mappings, and session stages
Proven industry experience in activities related to the development, implementation, administration and support of ETL processes for large - scale data warehouses using Informatica PowerCenter
Extensively contributed in the areas of Dimension, Star Schema, and Snowflake Modeling
Developed complex UNIX Shell Scripts, PowerShell and Batch Scripts, C#, VB .NET console applications/service for automation of ETL processes and Data transfer needs
Expert knowledge in writing complex SQL queries and stored procedures in Oracle, Teradata, Netezza, DB2 and SQL Server
Highly motivated and adaptive 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

Languages: Java, C, C++, SQL, PL/SQL, IBM Assembler, Pro*C, .NET

ETL Tools: Informatica PowerCenter, Power Exchange, CDC, SQL*Loader

OS: MS-DOS, Windows 9x/NT/2K/XP/10, UNIX (SOLARIS, HP-UX, AIX), Linux, MVS and OS/390, Windows Server 2012 R2

Methodologies: E-R Modeling, Star Schema, and Snowflake

Internet: JSP, Servlets, HTML, XML, XSD, XSL, XSLT, XML

Scripting: JavaScript, VBScript, Perl and UNIX Shell Scripting (Korn & C shell)

RDBMS: Oracle, Teradata V2R5, Netezza, DB2 UDB, SQL Server, and MS Access

PROFESSIONAL EXPERIENCE

Principal Software Developer/ETL Project Lead

Confidential, Washington, DC

Responsibilities:

Managed a team of 5 - 12 members
Delegated tasks and set expectations and deadlines
Conducted daily standup meetings
Interacted with the clients to clarify requirements and set expectations
Communicated strategy and timelines to the team
Defined scope of testing for QA team
Conducted code review sessions
Resolved project related issues and team conflicts
Conducted regular on-boarding sessions for new team members
Designed ETL system architecture that supports Federal Reserve’s annual DFAST stress testing
Developed ETL workflows to load data implementing best practices, code minimization and reusability
Developed reusable preprocessing scripts using PowerShell
Developed console application to change column order in flat files to expected format to enable successful processing using Microsoft .NET C#
Developed File Handler application to run workflows using Microsoft .NET VB
Developed Ad Hoc process to enable loading of files by client
Performed Informatica Admin activities such as Installation, Upgrades, Folder Security, etc.

Sr. ETL Developer/ Consultant

Confidential, Washington, DC

Responsibilities:

Designed and developed a console application to load BLOB documents to SQL Server database using Microsoft .NET C#
Maintained and Enhanced existing Informatica Mappings, Sessions and Workflows
Designed and developed Mappings using various Informatica Transformations like Expression, Lookup, Aggregate, Filter, Update Strategy, Sorter, Normalizer, and Router to extract, load, and create XML files
Used Informatica Mapping Variables and Parameters, Workflow Variables and Parameter files, Command Tasks, Email Tasks and external Scripts, Pre-Session and Post-Session SQL to create efficient and flexible end-to-end jobs
Designed and developed Structure, Supervisory and Shared National Credit (SNC) XML Processes
Designed, developed and modified XML Schemas
Designed and developed Incremental process to generate Data and/or Count files based on the record count using Informatica PowerCenter
Designed and developed reusable Informatica Incremental process to accurately flag the records' Transaction type using Lookup tables
Designed and developed an application using VBScript to Backup, Rename and Transfer, Receive, and verify status of transfer of files between agencies, using Connect:Direct

Environment: Informatica PowerCenter 8.1.1, PowerExchange CDC, XML, XSD, SQL Server 2005, Windows 2003, VBScript, .NET C#, DB2, MS-Visio, AS400, JCL, COBOL.

We provide IT Staff Augmentation Services!

Sr. Etl Developer/ Consultant Resume

Washington, DC

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship