TITLE: Senior Data Developer (Multiple Openings)
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 mapping 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 the 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 document and participate in 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 the performance of batch and response time of data for users. Use Teradata Data Mover to copy data and objects from one system to another. Create and maintain source-target mapping documents for ETL development team; engage in performance tuning of Informatica ETL mappings using caches and overriding SQL queries as well as by using parameter files. Develop ETL processes, programs, and solutions in accordance with established standards; diagnose moderate to complex issues.
Want more jobs like this?
Get Data and Analytics jobs in Darien, CT delivered to your inbox every week.
EDUCATION/REQUIREMENTS: Bachelor's degree (or foreign equivalent) in Computer Science, or a related field. 5 years of experience using SQL, Shell Script, Oracle, and Teradata to analyze and manage data in database; utilizing database design principles, including normalization, denormalization, indexing, and portioning; with data modeling tools such as ER diagrams or UML; utilizing database APIs and libraries, including JDBC and ODBC; optimizing database performance and troubleshooting issues related to query optimization, indexing, and storage; with data warehousing including ETL processes and data visualization tools; and 2 years of experience using Python to analyze and manage data in a database.
MPD392 2024-30229 2024
Here, employees don't just have jobs, they build careers. That's why we believe in offering a comprehensive pay and benefits package that rewards employees for their contributions to our success, supports all aspects of their well-being, and delivers real value at every stage of life.
A qualified applicant's criminal history, if any, will be considered in a manner consistent with applicable laws, including local ordinances.
Get to Know Us Charter Communications is known in the United States by our Spectrum brands, including: Spectrum Internet®, TV, Mobile and Voice, Spectrum Networks, Spectrum Enterprise and Spectrum Reach. When you join us, you're joining a strong community of more than 100,000 individuals working together to serve more than 32 million customers in 41 states and keep them connected to what matters most. Watch this video to learn more.
Who You Are Matters Here We're committed to growing a workforce that reflects our communities, and providing equal opportunities for employment and advancement. EOE, including disability/vets. Learn about our inclusive culture.