Senior ETL Developer

Our Client seeks an experienced professional for the position of Senior ETL Developer to support the Data Warehouse Project. This incumbent to this position will work with the business analyst to design and implement processes for sourcing data from various internal as well as external sources leveraging Operational Data Store and Data Mart concepts to facilitate timely, reliable and secure delivery of Data driven reports and analytics.

DUTIES AND RESPONSIBILITIES

Performs coding and/or configuration to meet documented needs, utilizing

standard procedures and techniques

Reviews, analyzes, and modifies programming systems, including coding,

testing, debugging and installing for a large-scale system; maintains records to

document program development and revisions

Advises business analysts on discrete technology-related business

problems, formulates options including assessing their relative merits and risks,

and works with business analysts to determine the best solution

Provides input into project estimates

QUALIFICATIONS:

5-10 years of experience in designing, implementing, testing, migrating, deploying and managing Oracle ETL solutions (OWB, ODI)for Data Warehouse projects

5-10 years of proven experience in design and development of integration/ETL components, PL/SQL procedures and functions

5-10 years of experience with OWB+, SQL, PL/SQL and reporting tools

Ability to successfully design, deploy and evolve ETL solutions to meet business requirements

Experience managing ETL operations

Job-stream definition and management, parameters, scheduling, monitoring, communication and alerting

Experience developing governance for ETL audit, balance and control

Job-execution statistics, balancing and controls, rejects and error-handling, codes management.

Experience designing, implementing, managing ETL utility layer: common components supporting all other layers including forecasting capacity/performance requirements and building scalable foundational ETL infrastructure to allow for future growth

Experience working with DBA's in implementing efficient databases, including specifying physical characteristics, gathering statistics, creating profiles, designing efficient indexes

Minimum 3-5 years hands-on experience with requirements gathering, design documentation, test case development, system & integration testing, custom off the shelf (COTS)/business intelligence (BI) implementations and systems integration

Bachelor's Degree preferred and 8-10 years of related experience or an equivalent combination of education and experience.

Strong problem solving/analytical skills

Must have excellent troubleshooting skills

Good multi-tasking skills

Good oral/written communication skills

Ability to interface with diverse teams

Ability to analyze data and data relationships

Ability to translate both business requirements & technical details

Ability to independently design programs and test plans

Good organizational skills

Excellent listening skills

ABOUT ESG CONSULTING:

ESG Consulting is an award-winning national provider of diversified information technology consulting services to Fortune 1000, public sector entities, and emerging growth firms nationwide.

Founded in 1986, ESG offers more than 26 years of experience in the IT staffing, Engineering and consulting industry. While local to Atlanta we are Headquartered in Santa Clara, we have opened offices nationwide and to this day are consistently re- evaluating and expanding our service offerings and geographic capabilities. Today, we serve most major metropolitan markets.

ESG is an equal opportunity company. Our flexible management culture believes in creating a business environment that fosters personal and professional growth and achievement. We make ESG a place where people are treated not as employees but as "partners".