20 days ago
Base Salary
$100k - $135k/yr
Responsibilities
- Design, develop, and maintain scalable ETL/ELT pipelines using Python, SQL, and Snowflake.
- Build ingestion and transformation processes from Oracle, SQL Server, APIs, flat files, and cloud object storage.
- Develop and optimize Snowflake databases, schemas, tables, views, stages, streams, tasks, and stored procedures.
- Write complex SQL for data transformation, analytics workloads, and large-volume processing.
- Implement data-quality controls, reconciliation, validation, duplicate and null checks, schema validation, and exception handling.
- Design logging, error handling, retry, monitoring, and alerting mechanisms for production pipelines.
- Troubleshoot data discrepancies, failed pipelines, performance bottlenecks, and production incidents.
- Apply Snowflake security concepts including RBAC, roles, privileges, secure views, and data-access controls.
- Build and maintain Git-based CI/CD development and deployment practices.
- Participate in code reviews, maintain technical documentation, and provide technical guidance to junior engineers.
Requirements
- 7+ years of experience in data engineering, ETL/ELT, data warehousing, or related development.
- Strong hands-on development experience with Snowflake.
- Advanced Python skills for data processing, automation, APIs, and pipeline development.
- Advanced SQL skills including joins, CTEs, window functions, stored procedures, query optimization, and large-volume data processing.
- Experience implementing data-quality, reconciliation, monitoring, and exception-handling frameworks.
- Strong troubleshooting and root-cause-analysis skills.
- Experience with Snowflake Streams, Tasks, Stages, Snowpipe, RBAC, query optimization, and warehouses.
- Experience with Git, REST APIs, Pandas, Oracle, SQL Server, CSV, JSON, Parquet, and XML.
Benefits
- Medical, dental, vision, and life insurance, subject to eligibility.
- Paid holidays and paid time off.
- 401(k) plan and contributions.
- Long-term and short-term disability coverage.
- Paid parental leave.
- Employee Stock Purchase Plan.
About Cognizant
Cognizant is a public IT services and consulting firm that designs, builds, and runs enterprise technology, including digital engineering, cloud modernization, data/AI, and managed services. It sells consulting, systems integration, and outsourcing on multi-year engagements to large enterprises in healthcare, banking, retail, communications, and manufacturing. Founded in 1994 and headquartered in Teaneck, New Jersey, Cognizant is NASDAQ-listed (CTSH) and a Fortune 500 company.