The Role
Lead design and development of high-performance ETL processes using Informatica PowerCenter. Implement and load Type 2 SCDs into star-schema datamarts, tune SQL/ETL performance, script in UNIX, schedule with Autosys, manage code in ClearCase, supervise staff, and integrate on-demand connectors (SAS, RDBDS, flat files).
Summary Generated by Built In
Company Description
Sarian Solutions Inc.
Trusted Partner for your all IT Needs.
Job DescriptionRole: ETL Tech Lead
- Minimum five 8 years of current and hands-on experience with Informatica Power Center (v 8.x and higher) design, development and performance tuning. This should include at least 1 year of v9.x experience.
- Minimum five 5 years of current and hands-on experience with reading and loading high-volume Type2 dimensions (Slowly Changing Dimensions) in Multi-Dimensional Datamarts (Start Schema).
- Minimum five 8 years of current and hands-on experience with SQL and Relational databases.
- Minimum five 5 years of current and hands-on UNIX shell scripting experience.
- Minimum five 5 years of current and hands-on experience in designing high performing ETLs in a complex Data Warehouse, Data Marts and Analytics Environments.
- Minimum five 5 years of current and hands-on experience with Performance Tuning of SQL and ETL Process for high volume and highcomplexity processing.
- Minimum two 4 years of current and hands-on Autosys experience.
- Minimum two 4 years of current and hands-on experience with code management tools such as ClearCase.
- Minimum three 3 years of experience in Staff supervisory role.
- Working knowledge of On-Demand connectors – SAS, RDBDS and flat files.
Role: Sr. ETL Developer
- Minimum five 5 years of current and hands-on experience with Informatica Power Center (v 8.x and higher) design, development and performance tuning. This should include at least 1 year of v9.x experience.
- Minimum five 5 years of current and hands-on experience with SQL and Relational databases and SQL Query performance tuning.
- Minimum five 5 years of current and hands-on UNIX shell scripting experience.
- Minimum two 2 years of current and hands-on Autosys experience.
- Minimum two 2 years of current and hands-on experience with code management tools such as ClearCase.
- ETL & Loadrunner
Will be provided on the call. Please, apply with your updated resume containing contact details...
Skills Required
- Informatica PowerCenter (v8.x and higher) design, development and performance tuning, including v9.x experience
- Experience reading and loading high-volume Type 2 Slowly Changing Dimensions in star-schema datamarts
- Strong SQL and relational database experience with query performance tuning
- UNIX shell scripting experience
- Designing high-performing ETLs for complex data warehouse, data marts, and analytics environments
- Performance tuning of SQL and ETL processes for high-volume processing
- Autosys experience
- Experience with code management tools such as ClearCase
- Staff supervisory experience
- Working knowledge of on-demand connectors (SAS, RDBDS, flat files)
- Experience with ETL tools and LoadRunner (listed under Qualifications)
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Sarian Solutions Inc. is a global information technology and business solutions provider specializing in IT consulting and staffing services. The company delivers comprehensive business solutions using digital technologies including cloud, mobile, security, and data analytics. As a trusted partner, they empower businesses of all sizes to achieve digital transformation through custom software development, strategic guidance, and global talent acquisition.
