SQL Developer

S&K GLOBAL SOLUTIONS LLC
Charlotte, NC, United States
29 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
8 years minimum
Working hours
Regular working hours
Job source

Tech stack

Cloud Computing Continuous Integration Data Validation Data Integration Extract Transform Load (ETL) Data Migration Data Mining Data Warehousing Database Development Database Schema Software Design Documents Data Intelligence
+12 more
Query Optimization Software Deployment SQL Stored Procedures PL-SQL SQL Databases Technical Data Management Systems Freeform SQL Informatica Powercenter Database Optimization Database Performance Git Bitbucket

Job description

  • Design, develop, test, and maintain complex SQL queries, stored procedures, functions, views, and database objects.
  • Develop and support ETL workflows using Informatica PowerCenter and/or Informatica Intelligent Data Management Cloud (IDMC).
  • Analyze business requirements and translate them into technical data solutions.
  • Perform data extraction, transformation, and loading (ETL) activities from multiple source systems.
  • Optimize database performance through query tuning and indexing strategies.
  • Troubleshoot ETL failures, data quality issues, and performance bottlenecks.
  • Collaborate with business analysts, data architects, and application teams to deliver data integration solutions.
  • Implement data validation, reconciliation, and quality checks.
  • Support production deployments and resolve production incidents.
  • Create and maintain technical design documentation and operational runbooks.
  • Participate in data migration, modernization, and cloud transformation initiatives.
  • CI/CD deployments

Requirements

Must Have Technical/Functional Skills Primary Skill: SQL ,PL/SQL Secondary: Informatica Experience: Minimum 10 years Roles & Responsibilities We are seeking an experienced SQL Developer with Informatica expertise to design, develop, and support enterprise data integration and data warehousing solutions. The ideal candidate should have strong hands-on experience in SQL development, ETL processes, data modeling, and Informatica PowerCenter/IDMC within a large-scale enterprise environment., * Experience in Git/Bitbucket

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

5:19 min

Executing queries and scheduling pipeline jobs within DataWorks

Qiyang Duan · LIVE

43 sec

Integrating automated review tools into existing developer workflows

Tim Gilboy Tim Gilboy

6:21 min

Investigating push inefficiencies with upstream Git experts

Jonathan Creamer · Coffee With Developers

1:06 min

Developer experience and project variety at scale

Alexandra Petri · World Congress 2023

1:56 min

Implementing state-driven deployment architecture using automated pipeline integration tools

Lian Li · World Congress 2023

56 sec

Favorite git commands and the importance of patch commits

Eileen Uchitelle Eileen Uchitelle +1 · Coffee With Developers

Videos

See all

Related articles

See all