ETL Informatica/Oracle Developer

$85,000 - $90,000/Yr

Datasys Software and Consulting Inc - Charlotte, NC

Full-time - Mid Level

Charlotte, NC

About the position

The ETL Informatica/Oracle Developer role at Datasys Software and Consulting Inc involves the analysis, design, development, implementation, and troubleshooting of data warehouse applications. The position requires expertise in developing ETL processes using Informatica and Oracle, as well as writing complex SQL queries to manipulate data within the data warehouse. The developer will collaborate with team members to design and implement data models and will be responsible for optimizing ETL workflows for performance and scalability.

Responsibilities

• Analysis, design, development, implementation, and troubleshooting of Data warehouse applications.
• Develop ETL processes using Informatica and Oracle to extract, transform, and load data efficiently.
• Write complex SQL queries to manipulate data within the data warehouse.
• Develop ETL mappings and scripts using Informatica Power Center 9.X/8.X/7.X and Power Exchange 8.X/7.X.
• Collaborate with team members to design and implement data models.
• Create ETL mappings, analyze and document OLAP reports, and prepare high-level and detailed design documents.
• Integrate various data sources such as Oracle, Teradata, DB2, SQL Server, XML files, and flat files into the staging area.
• Load data from Oracle and MS SQL Server databases into Teradata database.
• Design reusable transformations and mappings using Informatica Designer.
• Build Fact Tables, Dimensional Tables, handle Slowly Changing Dimensions and Surrogate keys.
• Write and test PL/SQL triggers, stored procedures, functions, and packages.
• Create unit test cases and conduct code reviews.
• Troubleshoot and optimize ETL workflows for performance and scalability.
• Stay updated on industry trends and best practices in ETL development.

Requirements

• 7+ years of experience in ETL development and data warehousing.
• 5 years of experience with Informatica Power Center.
• 5 years of experience with SQL.
• 5 years of experience in data warehouse development life cycle.
• Experience in OLTP Data Modelling and Data warehousing concepts.
• Experience in integrating various data sources into staging areas.
• Proficiency in writing and testing PL/SQL triggers, stored procedures, functions, and packages.
• Strong communication and interpersonal skills.

Nice-to-haves

• Experience in Java programming.
• Experience in the Banking and Financial services industry.

Benefits

• 401(k)
• Dental insurance
• Health insurance
• Paid time off
• Vision insurance