Senior Data Developer

Charter Communications; Stamford (CT); On-site; USD 90,000 - 130,000; Full time

Job summary

An established industry player is seeking a Senior Data Developer to assist stakeholders in defining data requirements and optimize data processes. In this role, you will perform in-depth data analysis, create complex mappings, and develop ETL processes using tools like Informatica and Teradata. You'll engage in performance tuning and ensure data integrity while collaborating with various data sources. This position offers an exciting opportunity to leverage your SQL and Python skills in a dynamic environment focused on data-driven decision-making. Join a forward-thinking team and make a significant impact on business outcomes.

Qualifications

• 5+ years of experience with SQL, Shell Script, Oracle, and Teradata.
• Experience with data modeling tools like ER diagrams or UML.
• 2 years of experience using Python for data analysis.

Responsibilities

• Assist stakeholders in defining data capture requirements and perform data analysis.
• Create complex mappings and optimize Teradata views and SQLs.
• Develop ETL processes in accordance with established standards.

Skills

SQL

Shell Script

Oracle

Teradata

Python

Database Performance Optimization

ETL Processes

Data Visualization Tools

Education

Bachelor's degree in Computer Science

Tools

Informatica

Data Modeling Tools

JDBC

ODBC

Job description

Title

Senior Data Developer

Location

Stamford, CT

Job Summary

Assist stakeholders in defining requirements for data capture that answer business questions and outcomes. Perform data analysis and gather metadata of source systems to facilitate requirement feasibility analysis. Create complex mappings using transformations including Source Qualifier, Router, Filter, Expression, Sorter, Aggregator, Normalizer, Joiner, Rank, Sequence Generator, Connected, Unconnected Lookup, and Update Strategy. Transform Logical Data Model to Physical Data Model, ensuring Primary Key and Foreign Key relationships in PDM, as well as consistency of definitions for Data Attributes and Primary Index considerations. Prepare low-level technical design documents and participate in the build/review of BTEQ Scripts, Fast Exports, Multiloads, and Fast Load scripts. Review unit test plans and system test cases; provide support during system tests, product integration testing, and UAT. Integrate various data sources including Oracle, SQL Server, Netezza, Fixed Width and Delimited Flat Files, DB2, and XML Files. Optimize and tune Teradata views and SQLs to improve batch performance and data response times. Use Teradata Data Mover to copy data and objects between systems. Create and maintain source-target mapping documents for the ETL development team; engage in performance tuning of Informatica ETL mappings using caches, overriding SQL queries, and parameter files. Develop ETL processes, programs, and solutions in accordance with established standards; diagnose moderate to complex issues. This position does not supervise team members directly; the supervisor, Director of Database Marketing, oversees the team.

Education/Requirements

Bachelor's degree in Computer Science or a related field. 5 years of experience with SQL, Shell Script, Oracle, and Teradata for data analysis and management, including database design principles such as normalization, denormalization, indexing, and partitioning. Experience with data modeling tools like ER diagrams or UML. Familiarity with database APIs and libraries such as JDBC and ODBC. Skills in database performance optimization and troubleshooting related to query tuning, indexing, and storage. Experience with data warehousing, ETL processes, and data visualization tools. Additionally, 2 years of experience using Python for data analysis and management.

*Experience may be gained pre-/during/post-degree completion.