The Data Warehouse ETL Developer is responsible for application development tasks and assignments related to data integration as well as preparation of detailed specifications, diagrams and other programming structures related to ETL processes. This individual will design, code, test, debug and document moderately complex programs and applications in addition to performing application maintenance tasks.
· Responsible for the design, development, documentation of ETL processes
· Work in a complex environment which includes Database, Job Scheduling/Automation/Performance Tools
· Participate in ETL Design sessions with the team
· Production support of new or changing mappings and workflows and produce technical specifications
· Responsible for the analysis, data profiling, development, and integration of disparate systems throughout all phases of the project life cycle
· Work as part of a team delivering high quality and efficient integration solutions
· Assist in ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL related activities
· Implement best practices and tune for optimization
· Complete assignments in a timely manner
· Complete any other work as assigned
Requirements
· Must have a Bachelors in Computer Science or related field
· At least 2-3 years of experience in technical development
· At least 2-3 years of experience with Informatica PowerCenter – Additional Experience with SSIS or Talend is a plus
· At least 2-3 years of experience with Oracle Database
· Possess great diligence while also being flexible to adapt to a dynamic environment and changing priorities.
· Excellent SQL, PL/SQL, and Database Skills - Python / R are a plus
· Some prior use of Toad for Oracle or any similar tools a plus
· Explicit Understanding of SQL and some experience in a database environment
· Familiarity with data modeling – Star/Snow-flake schemas
· Experience with erwin Data Modeler software a plus
· Experience working in a corporate IT or similar environment
· Persuasive communication skills
· Dependability and adaptability
· Ability to work in a team/collaborative setting
· Technical proficiency
...knowledge in WAN transport systems, LAN switch technology, routing protocols (EIGRP, OSPF, BGP4). ~ SDWAN is an added advantage ~ CCNA & SDWAN certification ~ WAN transport systems, LAN switch technology, routing protocols (EIGRP, OSPF, BGP4) & SDWAN ~ Multi-...
...This is a remote position. Looking for a fun and exciting job that you can do from the comfort of your own home? We're currently seeking a Remote Activities Consultant to join our team! This is the perfect opportunity for someone who loves helping...
...Careers With Purpose Sanford Health is one of the largest and fastest-growing not-for-profit health systems in the United States... ...documentation on patient condition and treatment provided, as well as understand all applicable legal, moral and ethical issues surrounding...
...seeking premium rifles for home defense, hunting, and sport shooting. As the Marketing Analyst , you will be responsible for the functions... ...dashboards, reports, and data visualizations to track market performance and deliver to key stakeholders. Collaborate with...
Hanna Interpreting Services LLC is a language service provider that connects bilingual and multilingual individuals with potential opportunities to serve as a freelance interpreter or translator. Our mission is to bridge the communication gap for those in need through ...