DWH Testing 4-7 Yrs Gurgaon - DWH Testing, Mapping Dataflow,ADF,SQL,Pyspark - Gurgaon, 4.00 - 7.00 yrs | Sampoorna (J50961)

job opening

Job Summary


Experience:

4.00 - 7.00  Years 

Industrial Type:

IT-Software/Software Services

Location:

Gurgaon

Functional Area:

IT Software - QA & Testing

Designation:

DWH Testing 4-7 Yrs Gurgaon

Key Skills:

DWH Testing, Mapping Dataflow,ADF,SQL,Pyspark

Educational Level:

Graduate/Bachelors

Job Post Date:

Stream of Study:

Degree:

BCA, BCS, BE-Comp/IT, BE-Other, BIS, BIT, BSc-Comp/IT, BSc-Other, BTech-Comp/IT, BTech-Other, MCA, ME-Comp/IT, ME-Other, MIS, MIT, MSc-Comp/IT, MS-Comp/IT, MSc-Other, MS-Other, MTech-Comp/IT, MTech-Other

Company Description


The operations generate the data, the data builds the agents, the agents run the operations, our experts bring the judgment. Together, they deliver outcomes clients can measure.
Their client has done the work that keeps global enterprises moving — across industries, across functions, and where it matters most. That real-world experience shapes the products we build. They’re grounded in process intelligence, informed by context, and strengthened with every client they serve.

We stay accountable for outcomes. We measure them. We govern them. And we own them through the last mile — in the P&L, in cycle times, in working capital — where results are real.


We are on it, because we are in it.

Job Description


PRIMARY DUTIES/RESPONSIBILITIES:
•Maintain and provide enhancements to data architecture within new/existing systems including Data Warehouse.
•Recommend and implement processes to improve data quality, data reliability, and database performance.
•Employ variety of ETL and integration tools for system and data integrations.
•Architect solutions that support data scientist and business stakeholders.
•Conduct ETL testing and data transformation testing.
•Develop data models for data science team that can be utilized for data mining.
•Maintain source to target documentation and process flow documentation.
•Take on DBMS responsibilities and wear multiple hats such as: ETL’s, serve as SQL Server DBA – Processes/Job/Error Handling/Troubleshooting/Scheduling, etc.
•Proactively monitor ETL Processes / Jobs

EXPERIENCE:
• Relevant hands-on work experience in a Datawarehouse testing role.
• ETL (Extract Transform Load)/ODS (Operational Data Store) experience.
• MS SQL Server
• Commercial Real Estate experience preferred.

EDUCATION:
• Bachelor’s degree in computer science or information technology from an accredited institution

SKILLS:
• ETL Tools: SSIS, Azure Data Factory (ADF) including API source exposure.,
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases and working knowledge of Azure.
• Proficient in Azure Managed MS SQL Server database including setting indexes, database security, and backups.
• Data Testing
• Fundamental knowledge of data warehouse concepts
• Data Warehouse testing
• Microsoft Fabric
• Should be able to Develop Azure Logic App, Azure Function
• Experience in data duality, source systems analysis, and business rules validation.
• Ability to write and understand Source to Target documentation.
• Detail oriented and meticulous approach to duties.
• Keep our data separated and secure. Familiarity with data and cybersecurity.
• Good analytical skills.
• A knack for independent and group work.
• Capacity to successfully manage a pipeline of duties with minimal supervision

announce
Did not find a matching job? You can still send your CV to jobs@sampoorna.com or Register Here