Job Title: MS SQL EDW SA /software enginee
Location: India, Remote
Duration: 6-12 Months Contract
Job Description:
Seeking a senior MS SQL EDW SA /software engineer responsible for leading and contributing to development activities supporting global Enterprise Data Warehouse Team. The ideal candidate will have a strong background in a heterogeneous data management environment. This individual should have extensive experience with data warehousing best practices and techniques and possess extensive knowledge, hands-on experience, and expertise with medium to large enterprise MS SQL data warehousing environments. This person will create the global EDM Development, Infrastructure & business interna and external data ETL process.
This position will be a highly visible member of Insurance industry the Enterprise Data Warehouse development team. This team focuses on the design, development, unit testing, and implementation of various Data Engineering solutions. You will be a part of EDW modernization projects and will impact how the data is processed, transformed, organized, and used for Corporate Reporting, Analytics and Data Science teams.
What will you do:
" Must Have Understanding on Accord Model in EDW
" Insurance industry experience is must
" Provide thought leadership to the build & development.
" Collaborate with Scrum Master in determining the sequence of development execution and own and deliver design artifacts for each sprint.
" Work closely with Principal Engineers, Solution, and Enterprise Architecture to ensure strategic solutions aligned with the enterprise reference architecture.
" Works independently to develop, configure, code, and test programs of varying complexity and scope
" Apply knowledge of the latest trends in the industry and engage with other team members to consult and help implement appropriate technology practices and solutions.
" Ensure implementations are highly scalable, highly available, performant, and secure.
" Estimate own and, in some cases feature-level work effort for input to project planning.
" Escalate delays, issues, risks, and highlights to project managers and/or project leads.
What You Bring
" Bachelor's Degree in Computer Science or related field or equivalent experience
" 7+ years of experience in software development and design experience with strong emphasis on Data warehousing concepts, database design patterns, ETL methodologies, Processing and Transforming massive quantities of Data, Data cleansing, Data wrangling, and Data quality
" 5+ years advanced hands-on experience in developing ETL processes using major RDBMS (e.g. SQL Server, Azure Synapse, Oracle, Exadata, DB2, Teradata) and SQL
" 3+ years strong hands-on experience using Cloud tools: Azure Databricks, Azure Delta lake, Azure Data Factory, SQL Server, Azure Synapse, Azure DevOps, Data Lake(ADLS), PySpark, Databricks Notebooks
" Experience with data warehouse design techniques including slow changing dimensions, aggregation, partitioning and indexing strategies
" You have experience with 'Lambda' architectures elegantly integrating real-time and batch mode compute and services loads and a deep understanding of the concepts behind distributed storage and computation, in both streaming and batch processing systems
" Strong problem solving and documentation skills.
" Experience with Agile methodology (Scrum)
" You have experience in performance tuning and troubleshooting complex distributed systems and running and maintaining services in 247 production environment
" Working experience in CI/CD pipeline activities using toolsets such as Azure DevOps and Azure Git Repo
" Experience with Jira, Confluence, and source code management tools.
" Knowledge of Stonebranch (Enterprise scheduling tool) and BI performance management tool (e.g. MicroStrategy, Tableau) experience is a plus
AboutUs:
InterSources Inc, a Certified Diverse Supplier, was founded in 2007, offers innovative solutions to help clients on Digital Transformations across various domains and industries. Our history spans over 15 years and today we are an Award-Winning Global Software Consultancy solving complex problems with technology. We recognize that our employees and our clients are our strengths as the diverse talents and opportunities they bring to the table enables us to grow as a global platform and they are causally linked with our success. We provide strategic and technical advice, and we have expertise in areas covering Artificial Intelligence, Cloud Migration, Custom Software Development, Data Analytics Infrastructure & Cloud Solutions, Cyber Security Services etc. We make reasonable accommodations for clients and employees and we do not discriminate based on any protected attribute including race, religion, colour, national origin, gender sexual orientation, gender identity, age, marital status. We also are a Google Cloud partner company. We align strategy with execution and provide secure service solutions by developing and using the latest technologies that thrives our resources to deliver industry leading capabilities to our clients and customers, making it convenient for our clients to do business with InterSources Inc. Our teams also drive growth by refining technology driven client experiences that put the users first, providing an unparalleled experience. This results in strengthening the core technologies of clients, enabling them to scale with flexibility, create seamless digital experiences and build lifelong relationships.