Database Developer

Database Developer SHADC5683876

Location : Westlake TX (2 weeks / month onsite)

MUST HAVE : PL / SQL, Co-Pilot, AWS and python are nice to have.

Job Description :

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 :