Urgently needed for
Senior Enterprise Data Engineer
Company: TriNet
The Senior Data Engineer will be working with the Enterprise Information Systems team to maintain and develop data integration solutions to support our Analytics platform. The candidate will need to understand business and technical requirements and translate this into data integration designs and solutions. The solutions must align with EDW, Data mart and ETL standards and guidelines. The data integration solutions will be based on Informatica with Oracle data warehouses/databases & Tableau for reporting platform. The position also requires supporting the SDLC process in terms of testing, deployment, and postproduction support.Essential Duties/Responsibilities
- Understand business requirements and convert them into detail technical specifications
- Design and Develop ETL programs primarily using various data movement tools.
- Extract, transform & load into dimension model structures of EDW & data marts
- Performance improvement & tuning of Informatica mappings, SQL & PL/SQL scripts
- Technical reviews, Data validation & end to end testing of ETL Objects, Source data analysis and data profiling.
- Develop new data integrations and support existing integrations.
- Create required documentation as per SDLC standards
- Perform Unit Testing of ETL Programs and support QE on End-to-End testing
Required for All Jobs
- Performs other duties as assigned
- Complies with all policies and standards
QUALIFICATIONSEducation
- Bachelor’s Degree in Computer Science/Engineering or equivalent experience preferred
Work Experience
- Typically 5+ years of experience in implementation of BI projects in a large-scale enterprise data warehouse environment required
- Typically 5+ years of experience in ETL Architecture and ETL products especially on Informatica 9 and above required
working experience in SFDC and PeopleSoft in areas of Sales, Marketing, Finance, or Support domains required * Knowledge of end-to-end SDLC process in EDW & BI projects
- Dimensional Modeling and Data warehouse, ODS concepts, such as star schemas, snowflakes and normalized data models
experience in ETL Architecture and ETL products especially on Informatica 9 and above * Experience in cloud native data ecosystems (build and maintain)Licenses and Certifications
- Informatica Powercenter preferred
Knowledge, Skills and Abilities
- Ability to coordinate effectively with On-site and Off-shore resources through Managed Service Providers & IT teams
- Working knowledge in data profiling tools and ETL tools such as Data Stage, Oracle Data Integrator will be a plus
- Knowledge of Reporting tools like Cognos, Tableau, Business Objects is desired
- Excellent verbal and written communication skills
- Knowledge of JIRA, Confluence Tools and other collaboration tools a plus
Work Environment:
- Work in clean, pleasant, and comfortable office setting. The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable persons with disabilities to perform the essential functions.
Travel Requirements
- No travel required
The salary range for this role is $96,200 to $230,800. The candidate’s final salary offer will be based on the candidate’s skills, education, work location and experience.A candidate’s compensation may also include bonuses consistent with TriNet’s corporate bonus plan.Additionally, subject to applicable eligibility requirements, TriNet offers permanent full-time employees a variety of benefits including medical, dental, and vision plans, life and disability insurance, a 401(K) savings plan, an employee stock purchase plan, eleven (11) Company observed holidays, PTO and a comprehensive leave program. Please click the following link for detailed information about our benefits offerings:Please Note: TriNet reserves the right to change or modify job duties and assignments at any time. The above job description is not all encompassing. Position functions and qualifications may vary depending on business necessity.TriNet is an Equal Opportunity Employer and does not discriminate against applicants based on race, religion, color, disability, medical condition, legally protected genetic information, national origin, gender, sexual orientation, marital status, gender identity or expression, sex (including pregnancy, childbirth or related medical conditions), age, veteran status or other legally protected characteristics. Any applicant with a mental or physical disability who requires an accommodation during the application process should contact recruiting@trinet.com to request such an accommodation.
Expected salary:
Location: USA
Job date: Fri, 05 Jul 2024 07:02:15 GMT
Apply for the job now!
[ad_2]