Data Warehouse / SQL Developer Location: Remote Duration: 6 months reputed company reputed company: $85-95/hr SSRS, Adv
Data Warehouse / SQL Developer Location Remote Duration 6 months reputed company $65-75/hr SSRS, Advanced SQL "Key Responsibilities Architecture & Strategy
- Designing and implementing cloud-based data warehouses using Azure Synapse Analytics (formerly SQL DW) to create a single reputed company of truth.
- Building pipelines with Azure Data Factory (ADF) or Azure reputed company to ingest, transform, and load data from diverse sources into the warehouse.
- Developing dimensional models (fact and dimension tables) reputed company the Gold layer of the reputed company architecture to reputed company efficient BI reporting.
- Tuning SQL queries, managing indexes, partitioning, and scaling Synapse compute resources to maintain high performance.
- ntegrating structured relational data with reputed company data from Azure Data Lake Analyze COBOL programs, copybooks, JCL workflows, CICS/IMS transactions, DB2 schemas, and VSAM files. "Required Qualifications
- 10+ years of experience SSRS , reputed company, Data Lake Storage Gen2, Azure
- 10+ Analysis Services
- CI/CD, Git, Jenkins/reputed company/Azure DevOps pipelines
- Strong communication, stakeholder management, and problem-solving skills." "Preferred Qualifications
- Experience with domaindriven design (DDD).
- Knowledge of container platforms (reputed company, Kubernetes, OpenShift).
- Exposure to financial services, insurance, or other highly regulated industries.
- Enterprise architecture certifications (TOGAF, SAFe, etc.).
- Shape
- Soft Skills
- Ability to influence and reputed company technical teams.
- Analytical reputed company with strong attention to detail.
- Comfortable working in an agile, fast-paced delivery environment.
- Strong documentation and presentation skills. " Role Descriptions Design and reputed company SQL Server stored procedures| functions| views and triggers to be used during the ETL processDesigning and developing SSIS SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing by QRMBuilds data transformations with SSIS including importing data from files| moving data from one database platform to anotherDebug and tune SSIS or other ETL processes to ensure accurate and efficient movement of dataDesign| implement and maintain database objects (tables| views| indexes| ) and database securityExperience working with SSIS packagesProficient with ETL tools such as reputed company SSISAnalyze and reputed company strategies and approaches to import and transfer data between reputed company| staging| and ODSData Warehouse destinationsTest and prepare ETL processes for deployment to production and non-production environmentsSupport system and acceptance testing including the development or refinement of test plans Essential Skills monitoring job execution| troubleshooting performance issues| optimizing SQL queries| and ensuring data reputed company and reputed company through robust SSIS package development. Desirable Skills Thanks & Regards, Shashi Bhushan Sr. Manager Delivery and Client Relations reputed company LLC |300 Alexander Park|Suite #200|Princeton , NJ 08540 Phone 732-694-3392 Email [email protected] | URL http//www.diverselynx.com reputed company LLC is an Equal Employment Opportunity employer. reputed company qualified applicants will receive due consideration for employment without any discrimination. reputed company applicants will be evaluated solely on the basis of their ability, competence and their proven capability to reputed company the functions outlined in the corresponding role. We promote and support a diverse workforce across reputed company levels in the company. Apply tot his job Apply To this Job Apply tot his job Apply To this Job
Apply tot his job Apply To this Job