Informatica ETL Designer

Job Details

• Participate in project that will take vendor files and load into Snowflake database using Informatica Cloud. Snowflake is the source of our client's enterprise reporting using Tableau.
• Participate in solution design activities including requirements gathering, ETL design & development
• Develop detail ETL programs for the project.
• Clearly document and communicate technical designs, solutions, and issues.
• Help to support and maintain production environment as needed.
• Adhere to and enforce our client's software development methodology and standards, which include functional and technical designs, code reviews, unit & integration testing, source control and packaging of code
• Collaborate with the quality assurance team in developing testing plans and streamlining testing activities

Required Skills:

• Expert in Informatica PowerCenter and Cloud for ETL development, data warehousing and ETL theory
• Expert in Snowflake database
• Data architecture experience: familiar with relational and dimensional data model, able to design solution based on existing data models.
• A strong sense of ownership
• An ability to work independently without strict oversight and without being handed a task-list of discrete steps. Should be able to take a loosely defined assignment and produce robust programs.
• An ability to accurately estimate and plan his/her design, development, and testing work.
• The ability to work collaboratively with team members from IT (BA, PM, integration developer) and the business (business leads and SMEs)
• An ability to quickly learn our specific environments, IT processes, and technical change management procedures, and then begin to productively complete design and development activities within two weeks of his/her start date.

Experience developing custom-built software using state-of-the-art software engineering principles and practices. This includes professional coding practices (modularity, documentation including code comments, high level designs, data flow diagrams, unit testing) as well as experience in different development methodologies (waterfall and agile). At least 5 years of this experience should be ETL development experience.

location: CHICAGO, Illinois

job type: Contract

salary: $62 - 72 per hour

work hours: 8am to 5pm

education: Bachelors

Required Skills:

• Participate in project that will take vendor files and load into Snowflake database using Informatica Cloud. Snowflake is the source of our client's enterprise reporting using Tableau.
• Participate in solution design activities including requirements gathering, ETL design & development
• Develop detail ETL programs for the project.
• Clearly document and communicate technical designs, solutions, and issues.
• Help to support and maintain production environment as needed.
• Adhere to and enforce our client's software development methodology and standards, which include functional and technical designs, code reviews, unit & integration testing, source control and packaging of code
• Collaborate with the quality assurance team in developing testing plans and streamlining testing activities

The essential functions of this role include:

• working weekends
• Experience level: Experienced
• Minimum 7 years of experience
• Education: Bachelors
• Skill: Informatica

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact

Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).

This posting is open for thirty (30) days.

Skills

• IT risk, Data modeling, Extract, transform, load, RESTful, Python, Collaboration, Application development, User stories, Agile, Scrum, Requirements analysis, Design, DevOps, Process engineering, DaaS, Business process, Workflow, Scalability, Data migration, Transformation, Data, Expect, Risk management framework, Analytical skill, Data mining, Data Science, Machine Learning (ML), Big data, Analytics, Business intelligence, Data Analysis, Data architecture, Database,Problem solving, Software development, Management, Military, Life insurance,Finance, Workday, Law, Recruiting

Qualifications

Successful candidates must demonstrate appropriate knowledge, skills, and abilities for a role. Listed below are skills, competencies, work experience, education, and required certifications/licensures needed to be successful in this position.

Preferred Skills

Analytical Thinking, Competitive Advantages, Data Analytics, Data Mining, Data Science, Machine Learning

Competencies

Application Delivery Process, Big Data Management and Analytics, Business Intelligence, Data Analysis - Software, Data Architecture, Database Structures, Effective Communications, Problem Solving, Software Development Life Cycle

Work Experience

Roles at this level typically require a university / college degree, with 3+ years of relevant / direct industry experience. Certifications are often desired. In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.

Education

Bachelors

Certifications

No Required Certification(s)

Licenses

No Required License(s)

Benefits

PNC offers a comprehensive range of benefits to help meet your needs now and in the future. Depending on your eligibility, options for full-time employees include: medical/prescription drug coverage (with a Health Savings Account feature), dental and vision options; employee and spouse/child life insurance; short and long-term disability protection; 401(k) with PNC match, pension and stock purchase plans; dependent care reimbursement account; back-up child/elder care; adoption, surrogacy, and doula reimbursement; educational assistance, including select programs fully paid; a robust wellness program with financial incentives.

In addition, PNC generally provides the following paid time off, depending on your eligibility*: maternity and/or parental leave; up to 11 paid holidays each year; 8 occasional absence days each year, unless otherwise required by law; between 15 to 25 vacation days each year, depending on career level; and years of service.

To learn more about these and other programs, including benefits for full time and part-time employees, visit > New to PNC.

Qualifications

Successful candidates must demonstrate appropriate knowledge, skills, and abilities for a role. Listed below are skills, competencies, work experience, education, and required certifications/licensures needed to be successful in this position.

Qualifications

Successful candidates must demonstrate appropriate knowledge, skills, and abilities for a role. Listed below are skills, competencies, work experience, education, and required certifications/licensures needed to be successful in this position.

Qualifications

Successful candidates must demonstrate appropriate knowledge, skills, and abilities for a role. Listed below are skills, competencies, work experience, education, and required certifications/licensures needed to be successful in this position.