Senior Software Engineer (etl) Job in Infostretch Corporation

Senior Software Engineer (ETL) Job at Infostretch

Company Description:

Infostretch is a pure-play digital engineering services firm focused on helping companies accelerate their digital initiatives from strategy and planning through execution. We leverage deep technical expertise, Agile methodologies and data-driven intelligence to modernize systems of engagement and simplify human/tech interaction. We deliver custom solutions that meet customers technology needs wherever they are in their digital lifecycle. Backed by Goldman Sachs and Everstone Capital, Infostretch works with both large enterprises and emerging innovators -- putting digital to work to enable new products and business models, engage with customers in new ways, and create sustainable competitive differentiation.

Description

This opportunity is for individuals who have Hands-on experience in data warehouse design and development.The Role demands more than a typical ETL lead role as it interacts outwardly on projects with architects, PMs, OPS, data modelers, developers, admins, DBAs and testers. This is a hands-on delivery-focused role, and the individual will be responsible for technical delivery of data warehouse and data integration projects.

Must have skills

• 3 - 5 years Hands on experience with Matillion/Informatica ETL in designing and developing ETL processes based on multiple sources using ETL tools.
• Experience in designingend to end ETL solutions
• Expert at all aspects of relational database design
• Experience working with engineering team with respect to database-related performance tuning, writing of complex SQL, indexing, etc.
• 3 - 5 years of experience working as Developer
• Willingness to work US hours.
• Strong communication skills
• Experience with Matillion, Snowflake, Mirth, Crimson, S3

Responsibilities

• Engage with customer to identify all native data sources in the customer's data warehouse that are needed to build the new analytic solution.
• Map out the ETL process using the new data sources to create a new analytic DataMart.
• Define the ETL and report schemas aimed at optimizing storage capacity and performance.
• Document the enrichment activity that must be applied to any new data but delegate the work to a team of ETL developers.
• Work with customer business users, customer data experts to make sure the solution meets all requirements both in data availability and performance.
• Share any new learnings internally with the project Manager, IT organization and Engineering to drive constant improvements to the infrastructure and the product that drives the ETL work and customer experience
• Should be aware of ETL best practices and performance tuning
• Good understanding of data mapping, data validation, data manipulation, data analysis use cases.
• Participation and contribution in quality assurance walk through of ETL components
• Support development teams with performance tuning and troubleshooting issues
• Proficient with a database SQL language for user defined database extract or
  update statement

Nice to Have:

• Experience with Tableau, QuickSight

Disclaimer:
If you feel that this is a good match for your skillsets, please submit a current word version of your resume along with a cover letter describing your skills, experience and salary expectations. We are an Equal Opportunity Employer (EOE). You can read our job applicant privacy policy .