ETL Developer

ETL Developer

Company Description

About Allegis Global Solutions

We are founded on a culture that is passionate about transforming the way the world acquires talent by delivering client-focused solutions that make a difference for businesses worldwide. From refining how businesses manage their contingent workforce to strengthening employer brands to recruit top talent, our integrated solutions drive business results. As an industry leader, we draw upon decades of experience to design innovative tools, products, and processes. We develop competitive practices that position organizations for growth and we deliver the insight needed to succeed in today's global marketplace. As a workplace, we focus on relationships – with each other, our clients and our candidates. In fact, serving others is one of our core values. We support open communication and recognize that giving constructive criticism can be even harder than receiving it. We appreciate the fearless and the passionate, who force us to be better. Everything we do sits on a pillar of diversity - diverse perspectives, backgrounds, and ideas drive innovation and make us successful. See what it's like to work at AGS by searching #LifeAtAGS on any social network.

FOR U.S. ONLY

AGS is an Equal Opportunity/Affirmative Action Employer (M/F/Disability/Veterans). We will consider all applications without regard to race, gender, sexual orientation, gender identity, age, color, religion, national origin, veteran status, disability, genetic information or any other status protected by applicable law. If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to disability, please call or email

Job Description

Job Summary

The Developer role is responsible for developing and supporting integration and automation solutions using Informatica, Unix scripting, PowerCenter mappings and workflows, IDQ mappings and mapplets, UDO transformations, and creation of complex XSDs. Serve as Informatica subject matter expert for team members and clients.

Responsibilities

• Responsible for establishing, developing, updating internal Enterprise software development standards and best practices for ETL development using Informatica and extension (including but not limited to Power Center mappings & workflow, IDQ mappings & mapplets, UDO transformations, creation of complex XSDs), Matillion, Snowflake, UNIX, Java, Shell scripting, Salesforce, Azure and Tableau)
• Analyze, plan, design, develop, test and implement innovative methods for advancing ETL processes.
• Responsible for partnering with Technical Manager to follow established Enterprise Software Development Life Cycle (SDLC) standards and maintaining the successful adherence to these standards across entire Technology Solutions team
• Monitors for technology advancements impacting Integration Center related tools (Informatica, Tableau, and Azure, etc.) and make recommendations to drive efficiencies and ROI.
• Utilize skills of communication, presentation, time management, organization and planning to successfully achieve team goals and objectives
• Responsible for updating Integration Center documentation and best practices library, ensuring this is kept up-to-date for reference and training material

Qualifications

Qualifications, Skills, and Experience

• Minimum Bachelor's degree in Computer Science or Information Systems
• 7 years of software development experience
• 7 years of experience using a relational database
• 7 years of ETL experience (analyze, plan, design, develop, test, implement, and change)
• Expert-level experience with Oracle SQL, PL/SQL, Informatica Stack (including but not limited to Power Center mappings & workflow, IDQ mappings & mapplets, UDO transformations, creation of complex XSD), UNIX, Java, Shell scripting, Salesforce, and Tableau
• 7 years of experience in data analysis and troubleshooting
• Hands-on experience with Snowflake databases and creating ELT jobs in Matillion
• Ability to a manage a team with a high-volume workload, providing varying levels of support when required.
• Expert knowledge of MS Office tools, including MS Excel, and MS Access
• Experience with data warehouses and sound understanding of data warehousing principles
• VBA development experience in Excel a plus
• Must have strong technical, organizational and communication skills (both written and verbal)
• Must have robust, problem-solving capabilities, strong analytical skills, be flexible and able to handle multiple tasks concurrently
• Aptitude for learning new technologies and learning on the fly

Additional Information

As a workplace, we focus on relationships – with each other, our clients and our candidates - in fact serving others is one of our core values. We support open communication and recognize that giving constructive criticism can be even harder than receiving it. We appreciate the fearless and the passionate, who force us to be better. Everything we do sits on a pillar of diversity - diverse perspectives, backgrounds and ideas drive innovation and make us successful.

See what it's like to work at AGS by searching #LifeAtAGS on any social network.

Experience LevelSenior Level

---