- Bachelor's or master's degree in a technology related field like Computer Science or Engineering with 10+ years of experience
- 10+ years of hands-on experience in architecting, crafting, and developing highly scalable distributed data processing systems
- 10+ years of experience in Data Warehousing, Data mart concepts & implementations especially in relational databases like Oracle, SQL Server, Netezza, Snowflake
- 10+ years of experience in ETL technologies especially in Informatica
- 8+ years of experience in SQL, PL/SQL, and performance tuning
- 5+ years of experience in modern object-oriented programming languages like Python/Spark
- 2+ years of experience in Snowflake & AWS, cloud technologies
- Experience with shell scripting, scheduling tool and willing to participate on weekend on call rotation is a must
- Experience with DevOps, Continuous Integration and Continuous Delivery (Jenkins, Stash, Concourse, Artifactory) is a plus
- Experience in Agile methodologies (Kanban and SCRUM) is a plus
- Experience in Informatica IDQ tools, Address doctor etc. is a plus
location: Durham, North Carolina
job type: Contract
work hours: 9am to 5pm
education: Bachelors
responsibilities:
The Expertise and Skills You Bring
- In-depth understanding of ETL & Data warehousing System
- Developing PL/SQL objects as per business logic in Teradata, PostgreSQL and/or Oracle databases.
- Performing SQL & PL/SQL code tuning, creation of partitions and indexes to improve performance
- Working experience with Informatica, Unix Programming/Shell Scripting is a must
- Working experience with Control-M or any other batch scheduling tool
- Sound understanding of the software development process including analysis, design, coding, system and user testing, problem resolution and planning
- strong analytical skills and ability to tackle issues and work through ambiguous situations by making timely decisions based on facts, knowledge, experience, and judgment
- Good interpersonal and client-handling skills with the ability to handle expectations and explain technical detail
- Consistent track record to multitask, prioritizes tasks, and quickly adjusts in a constantly evolving environment
- Collaborate with business and technology groups and should be able to present formal and informal presentations in various settings: one-on-one, small, and large groups, with peers, and senior management
- Ability to navigate organizationally to accomplish tasks and work on multiple efforts simultaneously and ability to work with multi-functional teams located across geographies
- Excellent conflict management and negotiation skills; eager to learn and continuously develop personal and technical capabilities
- High level of dedication, initiative, vision, passion and professional approach to time, costs, and deadlines
- Ability to handle production issues with accuracy and attention to detail; a methodical, investigative, and inquisitive mind; together with creative abilities
- Design robust batch and streaming programs and adhering to standards and best practices for these databases
- Enjoy analyzing data, identifying gaps, issues, patterns, and trends and can analyze application dependencies and conduct impact assessment of changes
qualifications:
- Experience level: Experienced
- Minimum 10 years of experience
- Education: Bachelors
skills:
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, 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 HRsupport@randstadusa.com.
For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information
