Description
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".