ETL Architect

Saama Campbell , CA 95011

Posted 1 week ago

Does solving complex business problems and real world challenges interest you? Do you enjoy seeing the impact your contributions make on a daily basis? Are you passionate about using data analytics to provide game changing solutions to the Global 2000 clients? Do you thrive in a dynamic work environment that constantly pushes you to be the best you can be and more? Are you ready to work with smart colleagues who drive for excellence in everything they do?

If you possess a solutions mindset, strong architecting skills, and commitment to be part of a tremendous journey, come join our growing, global team. See what Saama can do for your career and for your journey. .

Job Description

  • Provide technical leadership in the Design and the Development Phases of the SDLC lifecycle for the implementation of ETL components within the data warehouse architecture.

  • Own the Solution Architecture of the DW solution including the hardware and tool selection, capacity planning.

  • Create the Data Model, Technical Design of the DW Solution and detailed technical design on key aspects of the ETL components. Identify, design and help build repeatable and reusable ETL components.

  • Develop and Document Best Practices in all related areas.

  • Standardize, Design and help build frameworks for Error Handling, Data Recovery, Data Archival, Data Cleansing, Data Validation, Surrogate Key Management, Communication, Audit and Control and other support systems

  • Be a go-to person for all technical matters on the project for all teams including DBAs, System Administrators, SMEs, Analysts, Developers, QA

  • Ensure all metrics data is collected for all critical processes during the Design and the Development Phases of the SDLC lifecycle

  • Stay current with new and upcoming technological advances related to the DW (ETL) space in order to advise the business and IT on features, capabilities that may help enhance the capabilities to solve business problems more effectively.

Impact on the business: At Saama, our business is delivering solutions with world-class talent and services with most consultant satisfaction

Key relationships:

  • With all team members

  • Onsite and Offshore teams (in Pune, India)

  • Client Relationships

What We Value

  • Integrity: doing the right thing

  • Solutions: solving core, complex business challenges

  • Collaboration: working as one team

  • Innovation: changing the game

  • Transparency: communicating openly

  • Enjoy & Celebrate: having fun


  • Self-starter who gets results with minimal support and direction in a fast-paced environment.

  • Takes initiative; challenges the status quo to drive change.

  • Learns quickly; takes smart risks to experiment and learn.

  • Works well with others; builds trust and maintains credibility.

  • Planful: identifies and confirms key requirements in dynamic environments; anticipates tasks and contingencies.

  • Communicates effectively; productive communication with clients and all key stakeholders communication in both verbal and written communication.

  • Stays the course despite challenges & setbacks. Works well under pressure.

  • Strong analytical skills; able to apply inductive and deductive thinking to generate solutions for complex problems

Minimum Qualifications:

  • BS / MS degree in computer science or related discipline

  • 14 years of DW / BI / ETL Experience with 2 or more years of Architectural experience

  • Ability to Work collaboratively in global/multi-departmental project with a positive team spirit and ensure teamwork and coordination.

  • Extensive Hands on working experience of ETL tools, SQL and UNIX scripting

  • Ability to design and develop complex ETL processes

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Tableau Architect


Posted 3 weeks ago

VIEW JOBS 2/28/2019 12:00:00 AM 2019-05-29T00:00 Roles and responsibilities:- * Must have experience designing reports for stakeholders in Life Sciences Pharmaceutical Commercial and Sales Operations group, including insights around Sales (Demand vs Forecast, Normalized Units), Channel Performance, Inventory (Days on Hand, Channel vs Warehouse), Calls (Reach, Frequency, Adherence) * 12+ Years of experience in Tableau development and Good understanding of Tableau Architecture (Server components including different services) * Build and publish customized interactive Tableau reports and dashboards along with data refresh scheduling using Tableau Desktop and Tableau Server. * Ability to make right graph choices, use of data blending feature, Connect to several DB technologies, In-depth knowledge of Tableau access control & embedding visualization on web pages, Tableau Web Connector extra * Create Tableau Scorecards, Dashboards using stack bars, bar graphs, scattered plots, geographical maps, line/pie graphs, and charts * Able to explore options and suggest new solution and visualization techniques to the customer. * Strong data analysis experience, including data profiling, building customized views, writing SQL queries, understand DW data model * Must stay up to date on new and coming visualization technologies Saama Campbell CA

ETL Architect