Tech Evaluation Login
Tech Evaluation Signup
PasswordReset
Unsubscribe
PasswordReset
PasswordReset
PasswordReset
Register for Webinar
Register for Event
Job Channels
Skill Score
About Us
Contact Us
Our Blog
Toggle navigation
Home
Skill Score
DemandIndex
Jobs
FETCH Jobs
Java J2EE
Dot Net, C#
DBA
SAP
Admin, Networking
Datawarehousing
QA
Demo
Candidate
Recruiter
Services
Job Posting & Resume Access
Integrated Talent Sourcing
Sub Contractor Supply Chain
Merger & Acquisition
Candidate
Post Resume
Login
Create Job Alert
Recruiter
Login
Free Trial
Signup
Pricing
| Pricing
Dashboard
My Resumes
Resume List
Add Resume
Edit / Update Resume
My Jobs
Fetch Jobs
Matched Jobs
Applied Jobs
Looking for ETL Lead Developer, Cincinnati, OH
Cincinnati, OH
Cincinnati
OH
45999
Date
: Feb-21-20
2020-02-21
2021-02-20
Looking for ETL Lead Developer, Cincinnati, OH
Cincinnati, OH
Feb-21-20
Work Authorization
US Citizen
GC
H1B
OPT EAD, CPT EAD, GC EAD, L2 EAD, H4 EAD, TN EAD
Preferred Employment
Corp-Corp
W2-Permanent
W2-Contract
1099-Contract
Contract to Hire
Job Details
Experience
:
Architect
Rate/Salary ($)
:
DOE
Duration
:
LongTerm
Sp. Area
:
Data Warehousing/ETL
Sp. Skills
:
Informatica
Permanent Direct Hire
Consulting / Contract
H1B OK
Third Party OK
FULL_TIME, CONTRACTOR
Required Skills
:
ETL, Data Warehousing, Oracle, SQL, SQL Server, Agile, Informatica, Kanban, UAT
Preferred Skills
:
Domain
:
IT/Software, Financial, Insurance
Work Authorization
US Citizen
GC
OPT EAD, CPT EAD, GC EAD, L2 EAD, H4 EAD, TN EAD
H1B
Preferred Employment
Corp-Corp
W2-Permanent
W2-Contract
1099-Contract
Contract to Hire
Job Details
Experience
:
Architect
Rate/Salary ($)
:
DOE
Duration
:
LongTerm
Sp. Area
:
Data Warehousing/ETL
Sp. Skills
:
Informatica
Permanent Direct Hire
Consulting / Contract
H1B OK
Third Party OK
FULL_TIME, CONTRACTOR
Required Skills
:
ETL, Data Warehousing, Oracle, SQL, SQL Server, Agile, Informatica, Kanban, UAT
Preferred Skills
:
Domain
:
IT/Software, Financial, Insurance
IDC Technologies Inc.
Milpitas, CA
Post Resume to
View Contact Details &
Apply for Job
Job Description
:
ETL Lead Developer - support for Data Warehouse Production Incidents” role. Please find the skill set and responsibilities.
Location: Cincinnati, OH
Duration – long term
Skill set:
- Working experience on different Data bases – Oracle, SQL Server (Tools – TOAD, Oracle Developer, MS SQL Server)
- Good expertise on SQL queries
- Working experience on Enterprise Data Warehouse (EDW), Data marts(FDW, ADW, URS, CDM etc and Downstream systems
- Expertise on Root cause analysis and creating Firefighting scripts to correct the erred transactions/data
- Good expertise on Data model and Data Governance
- Experienced on Coverage Code Matrix (CCM) updates ,adding/updating values into Lookup tables and getting approvals from different stake holders.
- Good expertise on ETL development and good expertise on Informatica Tool workflows to find the root cause
- Good experience on Policy, Billing and Claims applications and functionality
- Good knowledge on Agile/Kanban methodologies
- Good communication skills
Responsibilities:
- Requirement gathering for Policy/claims conversion projects and production incidents
- Requirement gathering for stat fields, handling of new elements/business terms
- Setting up meetings with different stake holders to review the stat/new elements, share meeting notes across the team
- Update the look up tables (e.g. Product values, producers) in non-prod environments and validate the new entries are correct for testing
- Update the Dimension/Aggregate tables in non-prod environment with required policy details and validate the new entries are correct for testing
- Gathering requirement for onset/offset triggers in ADW, update the triggers document and working with QA for test scenarios
- Testing support – Before testing commences, ensure that
o CCM changes are approved if any
o ETL/Adaptor work is completed for stat/new elements
o Risk hierarchies are ready
o FDW Look up tables are updated with right entries
o Onset/offset triggers are updated in ADW
o Dimensional/Aggregate tables are updated with right entries
o Support for user testing in non-environments like INT and UAT
- Gathering details from Production incident, if details are not clear then coordinating with business uses (whoever raised)/ internal team members
- Root cause analysis on failed/incorrect transactions/data for all BU’s
- Collaborating with different teams if the fix is from other team members
- Providing the SQL scripts to firefight the incorrect transactions/data
- Providing the solution to ETL/CXML developers if the fix is from ETL mapping/ CXML adaptor change and coordinating for updates
- Coordinating with testing team to test the firefighter scripts/mapping changes/ adaptor changes in lower environments and get approval from business (if it looks good in lower environment) to deploy into production
- Month end production support
- Job monitoring, fixing job failure issues by analyzing the root cause
Client :
IDC
Turn OFF keyword highlights
Similar Jobs you may be interested in ..
Data Engineer
,
Blue Ash, OH
Jun-20-25
DMS Vision, Inc.
($) :
Market
Position: Data Engineer Location: Onsite in 11450 Grooms Road Blue Ash Ohio 45242 Contract: 12+ Months Contract Job Description: Accountable for developing and delivering technological responses to targeted business outcomes. Analyze, design and develop enterprise data and information architecture deliverables, focusing on data as an asset for the enterprise. Understand and follow reusable standards, design patterns, guidelines, and configurations to deliver valuable data and info
Apply
[Apply Individually]