SSIS / SQL Developer – Data Migration

Job not on LinkedIn

🔥 17 hours ago

🇵🇰 Pakistan – Remote

⏰ Full Time

🟡 Mid-level

🟠 Senior

🚰 Data Engineer

👻 Ghost score 22%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

HR POD - Hiring Talent Globally

WebsiteLinkedInAll Job Openings

11 - 50 employees

Founded 2023

👥 HR Tech

🎯 Recruiter

🤝 B2B

HR Tech • Recruitment • B2B

HR POD is a leading premium global recruitment agency dedicated to elevating human resource management services. With a focus on helping companies strategize and build robust HR frameworks, HR POD specializes in recruitment, training, and performance management. They pride themselves on serving a diverse client base, particularly in the tech industry, and adopt a data-driven approach to optimize HR practices that align with organizational goals. Their commitment to integrity, customer satisfaction, and excellence positions them as a reliable partner in enhancing talent acquisition and retention strategies for businesses worldwide.

📋 Description

• Design, develop, and maintain SSIS packages for ETL workflows, data transformation, and automated data loads • Analyze Oracle schemas, stored procedures, functions, and packages, and re-engineer them in T-SQL for SQL Server • Develop complex T-SQL queries, stored procedures, views, triggers, and functions for business logic and reporting • Analyze and re-engineer Java-based ETL applications, including JDBC data access, batch jobs, and stored-procedure calls, into SSIS/T-SQL equivalents • Recommend modernization approaches for legacy Java-based ETL and data-integration applications • Conduct unit testing, integration testing, and performance tuning of ETL pipelines and SQL scripts • Document migration strategies, data mapping specifications, ETL workflows, and technical runbooks • Monitor and troubleshoot ETL failures, data discrepancies, and performance bottlenecks across production and staging environments • Optimize SQL queries and SSIS packages using indexing strategies, query plans, and execution profiling • Ensure compliance with data governance, security policies, and regulatory requirements • Collaborate with business analysts, DBAs, and project managers to gather requirements and translate them into technical solutions • Provide post-migration support, issue resolution, and performance monitoring

🎯 Requirements

• Bachelor's degree in Computer Science, Information Technology, Software Engineering, or a related field; equivalent professional experience and certifications considered in lieu of a formal degree • 3+ years of hands-on experience building and managing SSIS packages • Strong proficiency in Microsoft SQL Server (2016/2019/2022), including T-SQL, query optimization, indexing, and database design • Solid experience with Oracle (10g/11g/12c/19c), including PL/SQL, Oracle data types, sequences, and schema management • Proven experience with Oracle-to-SQL Server migrations, including schema conversion, data mapping, validation, data profiling, cleansing, and reconciliation • Expertise in scalable ETL pipelines for large datasets, data quality, and transformation logic • Working knowledge of Java, Core Java, JDBC, JDK 8+, Maven, and Java IDEs such as IntelliJ IDEA or Eclipse • Ability to read, debug, and migrate legacy Java-based ETL and data-integration applications to SSIS/T-SQL • Familiarity with Spring Batch or Apache Camel • Proficiency in SSMS, Visual Studio (SSDT), Oracle SQL Developer or TOAD, and SSMA for Oracle • Experience with SSIS Catalog and SQL Server Agent for ETL job scheduling • Experience with Git, Azure DevOps, or TFS for version control is preferred • Experience with SSRS or Power BI for reporting integration is advantageous • Microsoft Certified: Azure Data Engineer Associate or equivalent SQL Server certification is preferred • Experience with Azure Data Factory or other cloud-based ETL platforms • Familiarity with data warehousing concepts, including star schema, snowflake schema, and slowly changing dimensions • Exposure to Azure cloud environments and Agile/Scrum methodologies • Knowledge of data lineage and metadata management tools • Strong analytical and problem-solving skills, attention to detail, and communication skills • Ability to manage multiple tasks and priorities in a fast-paced project environment • Ability to work independently and as part of a team

🏖️ Benefits

• Remote work from anywhere in Pakistan • USD salary