> Markdown version of [/jobs/ext/280147-technical-architect](https://www.wearedevelopers.com/jobs/ext/280147-technical-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Technical Architect - **Company:** Tata Consultancy Services Limited - **Location:** College Park, GA, United States - **Experience:** Expert - **Salary:** $100,000.0 - $132,000.0 - **Contract:** Permanent contract - **Skills:** Agile Methodology, CA Workload Automation Ae, Data Cleansing, Data Integration, Extract Transform Load (ETL), Data Transformation, Data Warehousing, Database Queries, Hadoop Distributed File System, MapReduce, Apache HBase, Apache Hive, JSON, Job Scheduling, NoSQL, Apache Oozie, Oracle (Applications), Parsing, Performance Tuning, PL-SQL, SQL Databases, Sqoop, System Testing, Extensible Markup Language (XML), Apache Zookeeper, Apache Yarn, Informatica Powercenter, Apache Spark, Apache Flume, Information Technology, Apache Kafka, Bitbucket, Software Version Control - **Published:** May 23, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=39ede0890f29c48f ## About the Role Do you have a Bachelor's degree?, Secondary: Oracle, SQL Experience: Minimum 10 years Roles & Responsibilities ETL Process Development: Design, develop, and maintain ETL processes using Informatica PowerCenter or other relevant Informatica tools. * Deep understanding of HDFS, YARN, MapReduce, Hive, Pig, HBase, Flume, Sqoop, Zookeeper, Oozie. * Experience with Spark, Kafka, NoSQL databases. * Experience in Agile Methodology * Experience with code versioning tools like Bit-Bucket * SQL Proficiency: Utilize SQL/PLSQL to extract, transform, and load data. * Exposure to advanced transformations like data transformations, Parsing JSON/XML messages * Experience in Job scheduling tools Like Autosys, Qualifications : BACHELOR OF COMPUTER SCIENCE ## Description * Data Integration: Integrate data from various sources, ensuring data consistency and quality. * Data Warehouse Design: Design and maintain data warehouses to support business intelligence activities. * Performance Optimization: Optimize SQL script/queries for speed and efficiency. * Troubleshooting: Identify and resolve issues in ETL processes. * Documentation: Create and maintain technical documentation for ETL processes. * Testing: Perform unit, integration, and system testing on ETL processes. * Collaboration: Collaborate with cross-functional teams to ensure successful implementation of ETL processes. * Data Quality: Ensure data quality by implementing data cleansing and transformation processes. * Data Modeling: Develop and maintain relational and dimensional data models. ## Related Videos - [Leveraging Real time data in FSIs](https://www.wearedevelopers.com/videos/806-leveraging-real-time-data-in-fsis) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Tomorrow's cloud data platforms - fully managed database-as-a-service (DBaaS)](https://www.wearedevelopers.com/videos/254-tomorrow-s-cloud-data-platforms-fully-managed-database-as-a-service-dbaas) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Introducing JSON Structure](https://www.wearedevelopers.com/videos/100219-introducing-json-structure) ## Related Articles - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [Best Paying Jobs in Technology](https://www.wearedevelopers.com/magazine/256-best-paying-jobs-in-technology)