Database Developer

Job Title: Database Developer 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: • 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.