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 ..
Java Developer
,
Cincinnati, OH
Apr-19-24
Omega Solutions, Inc
($) :
BASED ON EXPERIENCE
Details/Scope of the project: Responsible and accountable for risk by openly exchanging ideas and opinions, elevating concerns, and personally following policies and procedures as defined. Accountable for always doing the right thing for customers and colleagues, and ensures that actions and behaviors drive a positive customer experience. While operating within the Bank39;s risk appetite, achieves results by consistently identifying, assessing, managing, monitoring, and reporting risks of all ty
Apply
[Already Applied]
[Apply Individually]
Lead Java Developer
,
Cincinnati, OH
Apr-03-24
Technogen, Inc
($) :
USD 75 / Hourly / C2
Title: JFS-Programmer5/PR5 (731684) - Lead Java Developer Location: REMOTE WORK Duration: long term Contract Client: State of Ohio//JFS Responsibilities: Act as a Lead Developer for the Office of Information Services (OIS) Family Services Web applications Gain a deep Understanding of the applications to provide strong development and design for best business outcome Participate in requirements and design sessions Develop Java Code according to approved requirements and technic
Apply
[Already Applied]
[Apply Individually]
Lead Java Developer
,
Cincinnati, OH
Apr-04-24
Technogen, Inc
($) :
USD 80 / Hourly / C2
Role: Lead Java Developer Location: Cincinnati, OH (3 days a week) Top 3 skills - Java, RESTful API's, System Analysis Job Description: Position Summary: The Services Tech Lead will participate in activities that guide the direction, development, and delivery of software solutions that meet business needs. The Services Tech Lead will complete analysis and design tasks required to deliver critical business solutions. This role will establish estimates and work plans for design, develo
Apply
[Already Applied]
[Apply Individually]