Design, build, and optimize ETL pipelines and SQL Server databases using SSIS and T-SQL. Architect OLTP and OLAP schemas, implement data validation and cleansing, optimize query performance, automate deployments with CI/CD and Autosys, and collaborate with stakeholders to translate requirements into scalable data solutions.
Job Summary: We are seeking a senior Microsoft BI (SSIS) & SQL Server Database Developer responsible for building robust database structures and high-performance ETL processes. Responsibilities: • ETL Engineering (SSIS): Design and maintain end-to-end data integration packages using Control Flow and Data Flow tasks. Package deployment, configurations and automated scheduling using Autosys. • Database Development: Create and optimize critical database objects, including stored procedures, Functions, Triggers and Views using T-SQL. • Data Modeling: Architect relational schemas (OLTP) and dimensional models (OLAP) including Star and Snowflake schemas for data warehousing. • Troubleshoot and Optimize: Using tools like SQL Profiler , review execution plans to identify bottlenecks and optimize query performance through indexing and partitioning. • Ensure Data Quality and Integrity: Implement data validation, cleansing, transformation and reconciliation processes to ensure data accuracy and consistency throughout the data lifecycle. • Collaborate with Stakeholders: Work closely with IT teams and business stakeholders to gather data requirements and translate them to technical solutions. • Adhere to Best Practices: Participate in code reviews, establish coding standards, and implement CI/CD pipelines for automated testing and deployment. • Expert-level knowledge of SSIS. • Strong hands-on coding proficiency in Visual C# to extend SSIS beyond it’s built-in capabilities. • Experience with Code versioning tools (Bitbucket, Github) • Experience with CI/CD and setting up pipelines. • Solid understanding of database design principles, data modelling, schemas and data warehousing solutions. • Excellent problem-solving and analytical skills to troubleshoot complex data issues independently.
Similar Jobs
Information Technology • Consulting
Lead DataStage developer responsible for production support and enhancements: resolve incidents, perform root-cause analysis, implement CRs, develop and optimize DataStage jobs, tune Oracle SQL and UNIX processes, manage scheduling with Control-M, and follow SDLC and release procedures while interfacing with clients.
Top Skills:
Ci/CdControl-MIbm Infosphere DatastageLinuxOraclePl/SqlShell ScriptingSnowflakeSQLUnixVersion Control
Information Technology • Consulting
Lead extraction, post-processing and standardization of structured financial data from PDFs, HTML, XBRL and iXBRL using OCR and Python. Design scalable, validated ingestion workflows, collaborate across teams, deliver efficient compliant solutions, and mentor junior analysts.
Top Skills:
HTMLIxbrlOcrPdfPythonXbrl
Information Technology • Consulting
Lead extraction and standardization of structured financial data from complex formats (PDF, HTML, XBRL/iXBRL), apply OCR and validation, automate data pipelines, collaborate across teams, and mentor junior analysts.
Top Skills:
Ey.Ai Data Marketplace (Eydm)HTMLIxbrlOcrPdfPythonXbrl
What you need to know about the Delhi Tech Scene
Delhi, India's capital city, is a place where tradition and progress co-exist. While Old Delhi is known for its rich history and bustling markets, New Delhi is defined by its modern architecture. It's clear the region places a strong emphasis on preserving its cultural heritage while embracing technological advancements, particularly in artificial intelligence, which plays a central role in shaping the city's tech landscape, fueled by investments in research and development.
