Elizabeth Lancaster

IDR is seeking a highly skilled an experienced ETL Developer to join one of our top clients in the public sector industry. If you are looking for an opportunity to join a large organization and work within a team-oriented culture, please apply today!   Position Overview/Responsibilities for the ETL Developer: • Data acquisition from a variety of data sources for multiple uses. • Developing complex SQL scripts to transform the source data to fit into a dimensional model, then to create views and materialized views in Oracle. • Developing automation with Informatica IICS or Power Center to pull data from external data sources and transform it to fit into a dimensional model. • Collaborating with other members of the Data Engineering Team on the design and implementation of an optimal data design. • Verification and validation of SQL scripts, Informatica automation and database views. • Developing automated means of performing verification and validation. • Participating in all sprint ceremonies • Work closely with the Architects and Data Engineering Team on implementation designs and data acquisition strategies. • Enhance and maintain the Java web site that provides Tableau dashboards to an array of users with different roles. • Develop mockups and work with customers for validation • Working closely with other members of the team to address technical problems  • Assisting with the implementation and configuration of developmental tools • Producing and maintaining technical specifications, diagrams, or other documentation as needed to support the DD&I efforts  • Participation in requirements and design sessions  • Interpreting new and changing business requirements to determine the impact and proposing enhancements and changes to meet these new requirements  • All other duties as assigned. Required Skills for the ETL Developer:

• 8+ years’ experience developing mappings and workflows to automate ETL processes using Informatica IICS, IDMC or Power Center
• 8+ years’ experience acquiring and integrating data from multiple data sources/technologies using Informatica for use by a Tableau data visualization object. Data source techs should include Snowflake, Oracle, SQL Server, Excel, Access and Adobe PDF.
• 8+ years’ experience as a Data analyst for a data analytics, performance management system, or data warehousing project

What’s in it for you?

• Competitive compensation package
• Full Benefits; Medical, Vision, Dental, and more!
• Opportunity to get in with an industry-leading organization
• Close-knit and team-oriented culture

Why IDR?  

• 25+ Years of Proven Industry Experience in 4 major markets
• Employee Stock Ownership Program
• Medical, Dental, Vision, and Life Insurance
• ClearlyRated's Best of Staffing® Client and Talent Award winner 11 years in a row