ETL Informatica Lead Developer remote position
Indotronix Avani Group
Remote
lead
remote
remote
technical
tools
design
transformations
data
pl/sql
lead
design programming
programming
power center
March 16, 2023
Indotronix Avani Group
Seattle, Washington
Position : ETL Informatica Lead Developer
Position Location: Remote, however if in Pittsburgh, PA hybrid - in office 2 days a week
Ability to work remote: Yes
Describe the required must have technical skills, tools, or experience:
5-8 years of development experience
Advanced design and programming skills in Informatica power center 9.6 & above and Oracle SQL/PLSQL
Proficiency in developing and debugging the PL/SQL Code
Performance tuning of Targets, Source, Mappings, Sessions, and Workflows
Develop SCD mappings with difference source formats using necessary Transformations
Design HTTP Transformations
Experienced in handling the ETL Code deployments using DevOps Tools
Hands on knowledge with UNIX shell scripting and CA7 job scheduler
Intermediate level skills in data analysis and data modeling
Formal experience in working in projects with a methodology (waterfall, agile)
Does this position require any degrees or certifications for the candidate to be successful?
Bachelor's degree required, any certs welcomed, not required.
Interviews
Describe interview process (who will be involved, how many interviews, etc.):
2 rounds of technical interviews including informatica scenarios, 30 minutes each.
Position Location: Remote, however if in Pittsburgh, PA hybrid - in office 2 days a week
Ability to work remote: Yes
Describe the required must have technical skills, tools, or experience:
5-8 years of development experience
Advanced design and programming skills in Informatica power center 9.6 & above and Oracle SQL/PLSQL
Proficiency in developing and debugging the PL/SQL Code
Performance tuning of Targets, Source, Mappings, Sessions, and Workflows
Develop SCD mappings with difference source formats using necessary Transformations
Design HTTP Transformations
Experienced in handling the ETL Code deployments using DevOps Tools
Hands on knowledge with UNIX shell scripting and CA7 job scheduler
Intermediate level skills in data analysis and data modeling
Formal experience in working in projects with a methodology (waterfall, agile)
Does this position require any degrees or certifications for the candidate to be successful?
Bachelor's degree required, any certs welcomed, not required.
Interviews
Describe interview process (who will be involved, how many interviews, etc.):
2 rounds of technical interviews including informatica scenarios, 30 minutes each.
Report this job