ETL Developer

Description: Our client has an immediate need for an ETL Developer who will be responsible for designing, developing, and maintaining robust data integration and transformation solutions that support critical business applications and analytics initiatives. Must Have Technical Skills: • 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. • Develop SCD mappings with difference source formats using necessary Transformations. • Performance tuning of Targets, Source, Mappings, Sessions, and Workflows. • 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 • Flex Skills/Nice to Have: • Experience with Alteryx • BI tools such as Microsoft Power BI / Tableau / Oracle BI • Hands on Knowledge using Teradata • Working knowledge of software design patterns and architecture • Leads complex problem solving and provides technical guidance and support to colleagues and solution development. • Proposes, designs & codes software solutions to address complex business needs. • Oversees technical and procedural documentation as required Responsibilities: • Design, develop, and optimize ETL workflows and mappings using Informatica PowerCenter (v9.6 and above). • Write, test, and debug complex Oracle SQL/PLSQL code for data extraction, transformation, and loading. • Develop Slowly Changing Dimension (SCD) mappings from diverse data sources using appropriate Informatica transformations. • Perform performance tuning of ETL targets, sources, mappings, sessions, and workflows to ensure optimal performance. • Design and implement HTTP transformations within ETL processes. • Manage ETL code deployments and version control using DevOps tools and best practices. • Develop and maintain UNIX shell scripts for automation, job scheduling, and error handling. • Schedule and monitor ETL jobs using CA7 job scheduler. • Collaborate with data analysts and architects to support data modeling and ensure data quality and consistency. • Maintain documentation of ETL processes, workflows, and system dependencies. Why Work for ConsultUSA: • ConsultUSA offers competitive salaries, major medical (PPO or HDHP w/ HSA), dental, and vision insurance plans, and 401k plan with immediate eligibility for both salary and hourly employees • ConsultUSA hosts several outings and events, holiday and summer parties, and volunteer opportunities throughout the year for employees • We will work with you to obtain training for in-demand technologies and prepare you for industry-recognized certification exams • ConsultUSA offers Business Analysis and Project Management training through our Project Management Institute (PMI)® award-winning sister company, PMCentersUSA How to Apply: To submit your application, please click the “Apply Now” button located at the top and bottom of the page. ConsultUSA is committed to providing equal employment opportunities (EEO) to all qualified employees and applicants for employment without regard to race, color, religion, gender identity or expression, sexual orientation, national origin, age, disability, genetic information, marital status, pregnancy, ancestry, or status as a covered veteran as well as any other prohibited criteria under any applicable federal, state, and local laws applicable to ConsultUSA. For a complete listing of all ConsultUSA jobs please visit www.consultusa.com