Infogain is a human-centered digital platform and software engineering company headquartered in Silicon Valley. We specialize in engineering business outcomes for Fortune 500 companies and digital natives across various industries, including technology, healthcare, insurance, travel, telecom, and retail & CPG. Utilizing cutting-edge technologies such as cloud, microservices, automation, IoT, and artificial intelligence, we accelerate experience-led transformation in the delivery of digital platforms. As a Microsoft Gold Partner and Azure Expert Managed Services Provider (MSP), we pride ourselves on our commitment to excellence and innovation.
Job Responsibilities
- SQL Development. Design and develop SQL Server stored procedures, functions, views, and triggers to facilitate the ETL process.
- ETL Solutions. Design and implement SSRS/SSIS/SQL ETL solutions for data acquisition and preparation from various upstream systems.
- Data Transformation. Build data transformations using SSIS, including importing data from files and migrating data across database platforms. Generate reports using SSRS.
- Debugging & Tuning. Debug and optimize SSIS, SSRS, and other ETL processes to ensure accurate and efficient data movement.
- Database Management. Design, implement, and maintain database objects (tables, views, indexes, etc.) and enforce database security.
- Strategy Development. Analyze and devise strategies for importing and transferring data between source, staging, and ODS/Data Warehouse destinations.
- ETL Deployment. Test and prepare ETL processes for deployment to production and non-production environments.
- Testing Support. Assist in system and acceptance testing, including the development or refinement of test plans.
Qualifications
- Education. Bachelor’s degree in a relevant field.
- Experience. 4.5 to 6 years of hands-on experience as an SSIS/SSRS Developer or in a similar role.
Technical Skills
- Proficiency in SQL Server and experience with ETL tools such as Microsoft SSIS and SSRS.
- Familiarity with databases (e.g., MySQL, SQL Server, Oracle).
- Understanding of data warehousing, business intelligence, and regulatory reporting.
- Familiarity with Power BI or Tableau is advantageous.
- Experience in SQL Server installation and configuration, with skills in SQL query performance analysis.
Soft Skills
- Excellent communication and teamwork abilities.
- Strong problem-solving skills and the ability to multi-task in a challenging technical environment.
- Capacity to contribute individually while collaborating effectively within a team.
- Responds with speed and flexibility to meet dynamic project needs.
Join Us
At Infogain, we are committed to delivering innovative solutions that drive business success. If you are passionate about technology and eager to contribute to impactful projects in a dynamic environment, we invite you to apply for the SSIS/SSRS Developer position.