Senior PL/SQL Database Developer - Long-Term W2 Position
Visa Sponsorship
AI Summary
Develop robust ETL pipelines, integrate data from multiple sources, and maintain data integrity and consistency. Utilize PL/SQL, database stored procedures, and performance tuning. Implement best practices in data security and compliance.
Key Highlights
Develop and maintain ETL pipelines to integrate data from multiple sources
Utilize PL/SQL, database stored procedures, and performance tuning
Implement best practices in data security and compliance
Technical Skills Required
Benefits & Perks
W2 employment
Long-term position
Hybrid work arrangement (2 weeks/month onsite)
Potential sponsorship
Job Description
Job Title: Pl/SL Database Developer - W2 only - We can provide sponsorship
Duration: Long Term
Location: Westlake, TX - Hybrid - 2 weeks in a month onsite
MUST HAVE: PL/SQL, Co-Pilot, AWS and python are nice to have.
The Skills and Expertise You Bring
- Bachelor’s degree in computer science engineering or equivalent
- 8+ years of relevant experience in database development
- 8+ years hands-on RDBMS expertise (Oracle, Exadata, PostgreSQL).
- Extensive hands-on experience with ETL/ELT tools (Informatica, SnapLogic).
- Expertise in Data Analysis, Data Profiling and Data Modeling skills.
- Knowledge of Data Warehousing methodologies and concepts.
- Build and maintain robust ETL pipelines to integrate data from multiple sources into OLAP data stores, ensuring data integrity and consistency.
- Bring an innovative spirit in search of efficiencies, process improvement opportunities, technical improvements, and other ways to add value to the organization with focus on operations improvement.
- Extensive experience with PL/SQL, database stored procedures, and performance tuning.
- Proficiency in Python
- Proficiency with python for data movement/transformation including development of classes and object-oriented code.
- Complex batch cycle orchestration (tools like Control-M, Autosys or Crontab).
- Implement best practices in data security, role-based access control, and data masking to maintain compliance and data governance standards.
- Knowledge of Cloud platforms and Services (AWS – IAM, EC2, S3, Lambda, RDS).
- Knowledge of data streaming tools like Kafka, Kinesis.
- Design experience of scalable data models, optimized for data ingestion and analytics requirements including SCD.
- Developing and automating deployment with GIT, Jenkins, and CICD Processes.
Skills that are an advantage:
- Knowledge of non-RDBMS databases like Graph, No-SQL, Timeseries databases.
- Working knowledge of analytics and BI front-end tools like Power BI, Tableau, and ThoughtSpot.
- Financial Services experience.